<?php
/**
 *  @link http://github.com/zantoto
 *  @copyright Copyright (c) 2020 Zantoto
 *  @author 57620133@qq.com
 */

use yii\db\Migration;
use yii\helpers\Console;

class m120814_080818_add_area extends Migration
{
    public function up()
    {
        $tableOptions = null;
        if ($this->db->driverName === 'mysql') {
            // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
            $tableOptions = 'CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci';
        }

        Yii::$app->db->createCommand("DROP TABLE IF EXISTS {{%area_code}}")->execute();
        $this->createTable('{{%area_code}}', [
            'id' => $this->string(16),
            'type' => $this->integer()->notNull()->defaultValue(0)->comment('层级'),    // 1:国家, 2:省份, 3:市, 4:区县
            'name' => $this->string(64)->comment('名称'),
            'parent_id' => $this->string(16)->notNull()->defaultValue('')->comment('上级代码'),
            'zip' => $this->string(16)->comment('邮编'),
        ], $tableOptions);

        $this->addPrimaryKey('id', '{{%area_code}}', ['id']);
        $this->createIndex('parent_id', '{{%area_code}}', ['parent_id']);

        $sql = <<<EOD
        INSERT INTO {{%area_code}} (`id`, `type`, `name`, `parent_id`, `zip`) VALUES
        ('1', 1, '中国', '0', ''),
        ('110000', 2, '北京', '1', ''),
        ('110100', 3, '北京市', '110000', '100000'),
        ('110101', 4, '东城区', '110100', '100010'),
        ('110102', 4, '西城区', '110100', '100032'),
        ('110103', 4, '崇文区', '110100', '100061'),
        ('110104', 4, '宣武区', '110100', '100054'),
        ('110105', 4, '朝阳区', '110100', '100011'),
        ('110106', 4, '丰台区', '110100', '100071'),
        ('110107', 4, '石景山区', '110100', '100071'),
        ('110108', 4, '海淀区', '110100', '100091'),
        ('110109', 4, '门头沟区', '110100', '102300'),
        ('110111', 4, '房山区', '110100', '102488'),
        ('110112', 4, '通州区', '110100', '101100'),
        ('110113', 4, '顺义区', '110100', '101300'),
        ('110114', 4, '昌平区', '110100', '102200'),
        ('110115', 4, '大兴区', '110100', '102600'),
        ('110116', 4, '怀柔区', '110100', '101400'),
        ('110117', 4, '平谷区', '110100', '101200'),
        ('110228', 4, '密云县', '110100', '101500'),
        ('110229', 4, '延庆县', '110100', '102100'),
        ('110230', 4, '其它区', '110100', ''),
        ('120000', 2, '天津', '1', ''),
        ('120100', 3, '天津市', '120000', '300000'),
        ('120101', 4, '和平区', '120100', '300041'),
        ('120102', 4, '河东区', '120100', '300171'),
        ('120103', 4, '河西区', '120100', '300202'),
        ('120104', 4, '南开区', '120100', '300100'),
        ('120105', 4, '河北区', '120100', '300143'),
        ('120106', 4, '红桥区', '120100', '300131'),
        ('120107', 4, '塘沽区', '120100', '300450'),
        ('120108', 4, '汉沽区', '120100', '300480'),
        ('120109', 4, '大港区', '120100', '300270'),
        ('120110', 4, '东丽区', '120100', '300300'),
        ('120111', 4, '西青区', '120100', '300380'),
        ('120112', 4, '津南区', '120100', '300350'),
        ('120113', 4, '北辰区', '120100', '300400'),
        ('120114', 4, '武清区', '120100', '301700'),
        ('120115', 4, '宝坻区', '120100', '301800'),
        ('120116', 4, '滨海新区', '120100', '300457'),
        ('120221', 4, '宁河县', '120100', '301500'),
        ('120223', 4, '静海县', '120100', '301600'),
        ('120225', 4, '蓟县', '120100', '301900'),
        ('120226', 4, '其它区', '120100', ''),
        ('130000', 2, '河北省', '1', ''),
        ('130100', 3, '石家庄市', '130000', '050000'),
        ('130102', 4, '长安区', '130100', '050011'),
        ('130103', 4, '桥东区', '130100', '050011'),
        ('130104', 4, '桥西区', '130100', '050051'),
        ('130105', 4, '新华区', '130100', '050051'),
        ('130107', 4, '井陉矿区', '130100', '050100'),
        ('130108', 4, '裕华区', '130100', '050081'),
        ('130121', 4, '井陉县', '130100', '050300'),
        ('130123', 4, '正定县', '130100', '050800'),
        ('130124', 4, '栾城县', '130100', '051430'),
        ('130125', 4, '行唐县', '130100', '050600'),
        ('130126', 4, '灵寿县', '130100', '050500'),
        ('130127', 4, '高邑县', '130100', '051330'),
        ('130128', 4, '深泽县', '130100', '052560'),
        ('130129', 4, '赞皇县', '130100', '051230'),
        ('130130', 4, '无极县', '130100', '052460'),
        ('130131', 4, '平山县', '130100', '050400'),
        ('130132', 4, '元氏县', '130100', '051130'),
        ('130133', 4, '赵县', '130100', '051530'),
        ('130181', 4, '辛集市', '130100', '052360'),
        ('130182', 4, '藁城市', '130100', '052160'),
        ('130183', 4, '晋州市', '130100', '052260'),
        ('130184', 4, '新乐市', '130100', '050700'),
        ('130185', 4, '鹿泉市', '130100', '050200'),
        ('130186', 4, '其它区', '130100', ''),
        ('130200', 3, '唐山市', '130000', '063000'),
        ('130202', 4, '路南区', '130200', '063017'),
        ('130203', 4, '路北区', '130200', '063015'),
        ('130204', 4, '古冶区', '130200', '063104'),
        ('130205', 4, '开平区', '130200', '063021'),
        ('130207', 4, '丰南区', '130200', '063300'),
        ('130208', 4, '丰润区', '130200', '064000'),
        ('130223', 4, '滦县', '130200', '063700'),
        ('130224', 4, '滦南县', '130200', '063500'),
        ('130225', 4, '乐亭县', '130200', '063600'),
        ('130227', 4, '迁西县', '130200', '064300'),
        ('130229', 4, '玉田县', '130200', '064100'),
        ('130230', 4, '唐海县', '130200', '063200'),
        ('130281', 4, '遵化市', '130200', '064200'),
        ('130283', 4, '迁安市', '130200', '064400'),
        ('130284', 4, '其它区', '130200', ''),
        ('130300', 3, '秦皇岛市', '130000', '066000'),
        ('130302', 4, '海港区', '130300', '066000'),
        ('130303', 4, '山海关区', '130300', '066200'),
        ('130304', 4, '北戴河区', '130300', '066100'),
        ('130321', 4, '青龙满族自治县', '130300', '066500'),
        ('130322', 4, '昌黎县', '130300', '066600'),
        ('130323', 4, '抚宁县', '130300', '066300\r\n'),
        ('130324', 4, '卢龙县', '130300', '066400'),
        ('130398', 4, '其它区', '130300', ''),
        ('130399', 4, '经济技术开发区', '130300', ''),
        ('130400', 3, '邯郸市', '130000', '056000'),
        ('130402', 4, '邯山区', '130400', '056001'),
        ('130403', 4, '丛台区', '130400', '056004'),
        ('130404', 4, '复兴区', '130400', '056003'),
        ('130406', 4, '峰峰矿区', '130400', '056200'),
        ('130421', 4, '邯郸县', '130400', '056105'),
        ('130423', 4, '临漳县', '130400', '056600'),
        ('130424', 4, '成安县', '130400', '056700'),
        ('130425', 4, '大名县', '130400', '056900'),
        ('130426', 4, '涉县', '130400', '056400'),
        ('130427', 4, '磁县', '130400', '056500'),
        ('130428', 4, '肥乡县', '130400', '057550'),
        ('130429', 4, '永年县', '130400', '057150'),
        ('130430', 4, '邱县', '130400', '057450'),
        ('130431', 4, '鸡泽县', '130400', '057350'),
        ('130432', 4, '广平县', '130400', '057650'),
        ('130433', 4, '馆陶县', '130400', '057750'),
        ('130434', 4, '魏县', '130400', '056800'),
        ('130435', 4, '曲周县', '130400', '057250'),
        ('130481', 4, '武安市', '130400', '056300'),
        ('130482', 4, '其它区', '130400', ''),
        ('130500', 3, '邢台市', '130000', '054000'),
        ('130502', 4, '桥东区', '130500', '054001'),
        ('130503', 4, '桥西区', '130500', '054000'),
        ('130521', 4, '邢台县', '130500', '054001'),
        ('130522', 4, '临城县', '130500', '054300'),
        ('130523', 4, '内丘县', '130500', '054200'),
        ('130524', 4, '柏乡县', '130500', '055450'),
        ('130525', 4, '隆尧县', '130500', '055350'),
        ('130526', 4, '任县', '130500', '055150'),
        ('130527', 4, '南和县', '130500', '054400'),
        ('130528', 4, '宁晋县', '130500', '055550'),
        ('130529', 4, '巨鹿县', '130500', '055250'),
        ('130530', 4, '新河县', '130500', '055650'),
        ('130531', 4, '广宗县', '130500', '054600'),
        ('130532', 4, '平乡县', '130500', '054500'),
        ('130533', 4, '威县', '130500', '054700'),
        ('130534', 4, '清河县', '130500', '054800'),
        ('130535', 4, '临西县', '130500', '054900'),
        ('130581', 4, '南宫市', '130500', '055750'),
        ('130582', 4, '沙河市', '130500', '054100'),
        ('130583', 4, '其它区', '130500', ''),
        ('130600', 3, '保定市', '130000', '071000'),
        ('130602', 4, '新市区', '130600', '071052'),
        ('130603', 4, '北市区', '130600', '071000'),
        ('130604', 4, '南市区', '130600', '071000'),
        ('130621', 4, '满城县', '130600', '072150'),
        ('130622', 4, '清苑县', '130600', '071100'),
        ('130623', 4, '涞水县', '130600', '074100'),
        ('130624', 4, '阜平县', '130600', '073200'),
        ('130625', 4, '徐水县', '130600', '072550'),
        ('130626', 4, '定兴县', '130600', '072650'),
        ('130627', 4, '唐县', '130600', '072350'),
        ('130628', 4, '高阳县', '130600', '071500'),
        ('130629', 4, '容城县', '130600', '071700'),
        ('130630', 4, '涞源县', '130600', '074300'),
        ('130631', 4, '望都县', '130600', '072450'),
        ('130632', 4, '安新县', '130600', '071600'),
        ('130633', 4, '易县', '130600', '074200'),
        ('130634', 4, '曲阳县', '130600', '073100'),
        ('130635', 4, '蠡县', '130600', '071400'),
        ('130636', 4, '顺平县', '130600', '072250'),
        ('130637', 4, '博野县', '130600', '071300'),
        ('130638', 4, '雄县', '130600', '071800'),
        ('130681', 4, '涿州市', '130600', '072750'),
        ('130682', 4, '定州市', '130600', '073000'),
        ('130683', 4, '安国市', '130600', '071200'),
        ('130684', 4, '高碑店市', '130600', '074000'),
        ('130698', 4, '高开区', '130600', ''),
        ('130699', 4, '其它区', '130600', ''),
        ('130700', 3, '张家口市', '130000', '075000'),
        ('130702', 4, '桥东区', '130700', '075000'),
        ('130703', 4, '桥西区', '130700', '075061'),
        ('130705', 4, '宣化区', '130700', '075100'),
        ('130706', 4, '下花园区', '130700', '075300'),
        ('130721', 4, '宣化县', '130700', '075100'),
        ('130722', 4, '张北县', '130700', '076450'),
        ('130723', 4, '康保县', '130700', '076650'),
        ('130724', 4, '沽源县', '130700', '076550'),
        ('130725', 4, '尚义县', '130700', '076750'),
        ('130726', 4, '蔚县', '130700', '075700'),
        ('130727', 4, '阳原县', '130700', '075800'),
        ('130728', 4, '怀安县', '130700', '076150'),
        ('130729', 4, '万全县', '130700', '076250'),
        ('130730', 4, '怀来县', '130700', '075400'),
        ('130731', 4, '涿鹿县', '130700', '075600'),
        ('130732', 4, '赤城县', '130700', '075500'),
        ('130733', 4, '崇礼县', '130700', '076350'),
        ('130734', 4, '其它区', '130700', ''),
        ('130800', 3, '承德市', '130000', '067000'),
        ('130802', 4, '双桥区', '130800', '067000'),
        ('130803', 4, '双滦区', '130800', '067000'),
        ('130804', 4, '鹰手营子矿区', '130800', '067000'),
        ('130821', 4, '承德县', '130800', '067400'),
        ('130822', 4, '兴隆县', '130800', '067300'),
        ('130823', 4, '平泉县', '130800', '067500'),
        ('130824', 4, '滦平县', '130800', '068250'),
        ('130825', 4, '隆化县', '130800', '068150'),
        ('130826', 4, '丰宁满族自治县', '130800', '068350'),
        ('130827', 4, '宽城满族自治县', '130800', '067600'),
        ('130828', 4, '围场满族蒙古族自治县', '130800', '068450'),
        ('130829', 4, '其它区', '130800', ''),
        ('130900', 3, '沧州市', '130000', '061000'),
        ('130902', 4, '新华区', '130900', '061000'),
        ('130903', 4, '运河区', '130900', '061000'),
        ('130921', 4, '沧县', '130900', '061035'),
        ('130922', 4, '青县', '130900', '062650'),
        ('130923', 4, '东光县', '130900', '061600'),
        ('130924', 4, '海兴县', '130900', '061200'),
        ('130925', 4, '盐山县', '130900', '061300'),
        ('130926', 4, '肃宁县', '130900', '062350'),
        ('130927', 4, '南皮县', '130900', '061500'),
        ('130928', 4, '吴桥县', '130900', '061800'),
        ('130929', 4, '献县', '130900', '062250'),
        ('130930', 4, '孟村回族自治县', '130900', '061400'),
        ('130981', 4, '泊头市', '130900', '062150'),
        ('130982', 4, '任丘市', '130900', '062550'),
        ('130983', 4, '黄骅市', '130900', '061100'),
        ('130984', 4, '河间市', '130900', '062450'),
        ('130985', 4, '其它区', '130900', ''),
        ('131000', 3, '廊坊市', '130000', '065000'),
        ('131002', 4, '安次区', '131000', '065000'),
        ('131003', 4, '广阳区', '131000', '065000'),
        ('131022', 4, '固安县', '131000', '065500'),
        ('131023', 4, '永清县', '131000', '065600'),
        ('131024', 4, '香河县', '131000', '065400'),
        ('131025', 4, '大城县', '131000', '065900'),
        ('131026', 4, '文安县', '131000', '065800'),
        ('131028', 4, '大厂回族自治县', '131000', '065300'),
        ('131051', 4, '开发区', '131000', ''),
        ('131052', 4, '燕郊经济技术开发区', '131000', ''),
        ('131081', 4, '霸州市', '131000', '065700'),
        ('131082', 4, '三河市', '131000', '065200'),
        ('131083', 4, '其它区', '131000', ''),
        ('131100', 3, '衡水市', '130000', '053000'),
        ('131102', 4, '桃城区', '131100', '053000'),
        ('131121', 4, '枣强县', '131100', '053100'),
        ('131122', 4, '武邑县', '131100', '053400'),
        ('131123', 4, '武强县', '131100', '053300'),
        ('131124', 4, '饶阳县', '131100', '053900'),
        ('131125', 4, '安平县', '131100', '053600'),
        ('131126', 4, '故城县', '131100', '253800'),
        ('131127', 4, '景县', '131100', '053500'),
        ('131128', 4, '阜城县', '131100', '053700'),
        ('131181', 4, '冀州市', '131100', '053200'),
        ('131182', 4, '深州市', '131100', '053800'),
        ('131183', 4, '其它区', '131100', ''),
        ('140000', 2, '山西省', '1', ''),
        ('140100', 3, '太原市', '140000', '030000'),
        ('140105', 4, '小店区', '140100', '030032'),
        ('140106', 4, '迎泽区', '140100', '030024'),
        ('140107', 4, '杏花岭区', '140100', '030001'),
        ('140108', 4, '尖草坪区', '140100', '030003'),
        ('140109', 4, '万柏林区', '140100', '030027'),
        ('140110', 4, '晋源区', '140100', '030025'),
        ('140121', 4, '清徐县', '140100', '030400'),
        ('140122', 4, '阳曲县', '140100', '030100'),
        ('140123', 4, '娄烦县', '140100', '030300'),
        ('140181', 4, '古交市', '140100', '030200'),
        ('140182', 4, '其它区', '140100', ''),
        ('140200', 3, '大同市', '140000', '037000'),
        ('140202', 4, '城区', '140200', '037008'),
        ('140203', 4, '矿区', '140200', '037001'),
        ('140211', 4, '南郊区', '140200', '037001'),
        ('140212', 4, '新荣区', '140200', '037002'),
        ('140221', 4, '阳高县', '140200', '038100'),
        ('140222', 4, '天镇县', '140200', '038200'),
        ('140223', 4, '广灵县', '140200', '037500'),
        ('140224', 4, '灵丘县', '140200', '034400'),
        ('140225', 4, '浑源县', '140200', '037400'),
        ('140226', 4, '左云县', '140200', '037100'),
        ('140227', 4, '大同县', '140200', '037300'),
        ('140228', 4, '其它区', '140200', ''),
        ('140300', 3, '阳泉市', '140000', '045000'),
        ('140302', 4, '城区', '140300', '045000'),
        ('140303', 4, '矿区', '140300', '045000'),
        ('140311', 4, '郊区', '140300', '045011'),
        ('140321', 4, '平定县', '140300', '045200'),
        ('140322', 4, '盂县', '140300', '045100'),
        ('140323', 4, '其它区', '140300', ''),
        ('140400', 3, '长治市', '140000', '046000'),
        ('140421', 4, '长治县', '140400', '047100'),
        ('140423', 4, '襄垣县', '140400', '046200'),
        ('140424', 4, '屯留县', '140400', '046100'),
        ('140425', 4, '平顺县', '140400', '047400'),
        ('140426', 4, '黎城县', '140400', '047600'),
        ('140427', 4, '壶关县', '140400', '047300'),
        ('140428', 4, '长子县', '140400', '046600'),
        ('140429', 4, '武乡县', '140400', '046300'),
        ('140430', 4, '沁县', '140400', '046400'),
        ('140431', 4, '沁源县', '140400', '046500'),
        ('140481', 4, '潞城市', '140400', '047500'),
        ('140482', 4, '城区', '140400', '046011'),
        ('140483', 4, '郊区', '140400', '046011'),
        ('140484', 4, '高新区', '140400', ''),
        ('140485', 4, '其它区', '140400', ''),
        ('140500', 3, '晋城市', '140000', '048000'),
        ('140502', 4, '城区', '140500', '048000'),
        ('140521', 4, '沁水县', '140500', '048200'),
        ('140522', 4, '阳城县', '140500', '048100'),
        ('140524', 4, '陵川县', '140500', '048300'),
        ('140525', 4, '泽州县', '140500', '048012'),
        ('140581', 4, '高平市', '140500', '048400'),
        ('140582', 4, '其它区', '140500', ''),
        ('140600', 3, '朔州市', '140000', '036000'),
        ('140602', 4, '朔城区', '140600', '038500'),
        ('140603', 4, '平鲁区', '140600', '038600'),
        ('140621', 4, '山阴县', '140600', '036900'),
        ('140622', 4, '应县', '140600', '037600'),
        ('140623', 4, '右玉县', '140600', '037200'),
        ('140624', 4, '怀仁县', '140600', '038300'),
        ('140625', 4, '其它区', '140600', ''),
        ('140700', 3, '晋中市', '140000', '030600'),
        ('140702', 4, '榆次区', '140700', '030600'),
        ('140721', 4, '榆社县', '140700', '031800'),
        ('140722', 4, '左权县', '140700', '032600'),
        ('140723', 4, '和顺县', '140700', '032700'),
        ('140724', 4, '昔阳县', '140700', '045300'),
        ('140725', 4, '寿阳县', '140700', '045400'),
        ('140726', 4, '太谷县', '140700', '030800'),
        ('140727', 4, '祁县', '140700', '030900'),
        ('140728', 4, '平遥县', '140700', '031100'),
        ('140729', 4, '灵石县', '140700', '031300'),
        ('140781', 4, '介休市', '140700', '032000'),
        ('140782', 4, '其它区', '140700', ''),
        ('140800', 3, '运城市', '140000', '044000'),
        ('140802', 4, '盐湖区', '140800', '044300'),
        ('140821', 4, '临猗县', '140800', '044100'),
        ('140822', 4, '万荣县', '140800', '044200'),
        ('140823', 4, '闻喜县', '140800', '043800'),
        ('140824', 4, '稷山县', '140800', '043200'),
        ('140825', 4, '新绛县', '140800', '043100'),
        ('140826', 4, '绛县', '140800', '043600'),
        ('140827', 4, '垣曲县', '140800', '043700'),
        ('140828', 4, '夏县', '140800', '044400'),
        ('140829', 4, '平陆县', '140800', '044300'),
        ('140830', 4, '芮城县', '140800', '044600'),
        ('140881', 4, '永济市', '140800', '044500'),
        ('140882', 4, '河津市', '140800', '043300'),
        ('140883', 4, '其它区', '140800', ''),
        ('140900', 3, '忻州市', '140000', '034000'),
        ('140902', 4, '忻府区', '140900', '034000'),
        ('140921', 4, '定襄县', '140900', '035400'),
        ('140922', 4, '五台县', '140900', '035500'),
        ('140923', 4, '代县', '140900', '034200'),
        ('140924', 4, '繁峙县', '140900', '034300'),
        ('140925', 4, '宁武县', '140900', '036700'),
        ('140926', 4, '静乐县', '140900', '035100'),
        ('140927', 4, '神池县', '140900', '036100'),
        ('140928', 4, '五寨县', '140900', '036100'),
        ('140929', 4, '岢岚县', '140900', '036300'),
        ('140930', 4, '河曲县', '140900', '036500'),
        ('140931', 4, '保德县', '140900', '036600'),
        ('140932', 4, '偏关县', '140900', '036400'),
        ('140981', 4, '原平市', '140900', '034100'),
        ('140982', 4, '其它区', '140900', ''),
        ('141000', 3, '临汾市', '140000', '041000'),
        ('141002', 4, '尧都区', '141000', '041000'),
        ('141021', 4, '曲沃县', '141000', '043400'),
        ('141022', 4, '翼城县', '141000', '043500'),
        ('141023', 4, '襄汾县', '141000', '041500'),
        ('141024', 4, '洪洞县', '141000', '041600'),
        ('141025', 4, '古县', '141000', '042400'),
        ('141026', 4, '安泽县', '141000', '042500'),
        ('141027', 4, '浮山县', '141000', '042600'),
        ('141028', 4, '吉县', '141000', '042200'),
        ('141029', 4, '乡宁县', '141000', '042100'),
        ('141030', 4, '大宁县', '141000', '042300'),
        ('141031', 4, '隰县', '141000', '041300'),
        ('141032', 4, '永和县', '141000', '041400'),
        ('141033', 4, '蒲县', '141000', '041200'),
        ('141034', 4, '汾西县', '141000', '031500'),
        ('141081', 4, '侯马市', '141000', '043000'),
        ('141082', 4, '霍州市', '141000', '031400'),
        ('141083', 4, '其它区', '141000', ''),
        ('141100', 3, '吕梁市', '140000', '033000'),
        ('141102', 4, '离石区', '141100', '033000'),
        ('141121', 4, '文水县', '141100', '032100'),
        ('141122', 4, '交城县', '141100', '030500'),
        ('141123', 4, '兴县', '141100', '033601'),
        ('141124', 4, '临县', '141100', '033200'),
        ('141125', 4, '柳林县', '141100', '033300'),
        ('141126', 4, '石楼县', '141100', '032500'),
        ('141127', 4, '岚县', '141100', '033500'),
        ('141128', 4, '方山县', '141100', '033100'),
        ('141129', 4, '中阳县', '141100', '033400'),
        ('141130', 4, '交口县', '141100', '032400'),
        ('141181', 4, '孝义市', '141100', '032208'),
        ('141182', 4, '汾阳市', '141100', '032200'),
        ('141183', 4, '其它区', '141100', ''),
        ('150000', 2, '内蒙古自治区', '1', ''),
        ('150100', 3, '呼和浩特市', '150000', '010000'),
        ('150102', 4, '新城区', '150100', '010050'),
        ('150103', 4, '回民区', '150100', '010030'),
        ('150104', 4, '玉泉区', '150100', '010020'),
        ('150105', 4, '赛罕区', '150100', '010020'),
        ('150121', 4, '土默特左旗', '150100', '010100'),
        ('150122', 4, '托克托县', '150100', '010200'),
        ('150123', 4, '和林格尔县', '150100', '011500'),
        ('150124', 4, '清水河县', '150100', '011600'),
        ('150125', 4, '武川县', '150100', '011700'),
        ('150126', 4, '其它区', '150100', ''),
        ('150200', 3, '包头市', '150000', '014000'),
        ('150202', 4, '东河区', '150200', '014040'),
        ('150203', 4, '昆都仑区', '150200', '014010'),
        ('150204', 4, '青山区', '150200', '014030'),
        ('150205', 4, '石拐区', '150200', '014070'),
        ('150206', 4, '白云矿区', '150200', '014080'),
        ('150207', 4, '九原区', '150200', '014060'),
        ('150221', 4, '土默特右旗', '150200', '014100'),
        ('150222', 4, '固阳县', '150200', '014200'),
        ('150223', 4, '达尔罕茂明安联合旗', '150200', '014500'),
        ('150224', 4, '其它区', '150200', ''),
        ('150300', 3, '乌海市', '150000', '016000'),
        ('150302', 4, '海勃湾区', '150300', '016000'),
        ('150303', 4, '海南区', '150300', '016030'),
        ('150304', 4, '乌达区', '150300', '016040'),
        ('150305', 4, '其它区', '150300', ''),
        ('150400', 3, '赤峰市', '150000', '024000'),
        ('150402', 4, '红山区', '150400', '024020'),
        ('150403', 4, '元宝山区', '150400', '024076'),
        ('150404', 4, '松山区', '150400', '024005'),
        ('150421', 4, '阿鲁科尔沁旗', '150400', '025550'),
        ('150422', 4, '巴林左旗', '150400', '025450'),
        ('150423', 4, '巴林右旗', '150400', '025150'),
        ('150424', 4, '林西县', '150400', '025250'),
        ('150425', 4, '克什克腾旗', '150400', '025350'),
        ('150426', 4, '翁牛特旗', '150400', '024500'),
        ('150428', 4, '喀喇沁旗', '150400', '024400'),
        ('150429', 4, '宁城县', '150400', '024200'),
        ('150430', 4, '敖汉旗', '150400', '024300'),
        ('150431', 4, '其它区', '150400', ''),
        ('150500', 3, '通辽市', '150000', '028000'),
        ('150502', 4, '科尔沁区', '150500', '028000'),
        ('150521', 4, '科尔沁左翼中旗', '150500', '029300'),
        ('150522', 4, '科尔沁左翼后旗', '150500', '028100'),
        ('150523', 4, '开鲁县', '150500', '028400'),
        ('150524', 4, '库伦旗', '150500', '028200'),
        ('150525', 4, '奈曼旗', '150500', '028300'),
        ('150526', 4, '扎鲁特旗', '150500', '029100'),
        ('150581', 4, '霍林郭勒市', '150500', '029200'),
        ('150582', 4, '其它区', '150500', ''),
        ('150600', 3, '鄂尔多斯市', '150000', '017004'),
        ('150602', 4, '东胜区', '150600', '017000'),
        ('150621', 4, '达拉特旗', '150600', '014300'),
        ('150622', 4, '准格尔旗', '150600', '017100'),
        ('150623', 4, '鄂托克前旗', '150600', '016200'),
        ('150624', 4, '鄂托克旗', '150600', '016100'),
        ('150625', 4, '杭锦旗', '150600', '017400'),
        ('150626', 4, '乌审旗', '150600', '017300'),
        ('150627', 4, '伊金霍洛旗', '150600', '017200'),
        ('150628', 4, '其它区', '150600', ''),
        ('150700', 3, '呼伦贝尔市', '150000', '021008'),
        ('150702', 4, '海拉尔区', '150700', '021000'),
        ('150721', 4, '阿荣旗', '150700', '162750'),
        ('150722', 4, '莫力达瓦达斡尔族自治旗', '150700', '162850'),
        ('150723', 4, '鄂伦春自治旗', '150700', '165450'),
        ('150724', 4, '鄂温克族自治旗', '150700', '021100'),
        ('150725', 4, '陈巴尔虎旗', '150700', '021500'),
        ('150726', 4, '新巴尔虎左旗', '150700', '021200'),
        ('150727', 4, '新巴尔虎右旗', '150700', '021300'),
        ('150781', 4, '满洲里市', '150700', '021400'),
        ('150782', 4, '牙克石市', '150700', '162650'),
        ('150783', 4, '扎兰屯市', '150700', '162650'),
        ('150784', 4, '额尔古纳市', '150700', '022250'),
        ('150785', 4, '根河市', '150700', '022350'),
        ('150786', 4, '其它区', '150700', ''),
        ('150800', 3, '巴彦淖尔市', '150000', '015001'),
        ('150802', 4, '临河区', '150800', '015001'),
        ('150821', 4, '五原县', '150800', '015100'),
        ('150822', 4, '磴口县', '150800', '015200'),
        ('150823', 4, '乌拉特前旗', '150800', '015400'),
        ('150824', 4, '乌拉特中旗', '150800', '015300'),
        ('150825', 4, '乌拉特后旗', '150800', '015500'),
        ('150826', 4, '杭锦后旗', '150800', '015400'),
        ('150827', 4, '其它区', '150800', ''),
        ('150900', 3, '乌兰察布市', '150000', '012000'),
        ('150902', 4, '集宁区', '150900', '012000'),
        ('150921', 4, '卓资县', '150900', '012300'),
        ('150922', 4, '化德县', '150900', '013350'),
        ('150923', 4, '商都县', '150900', '013400'),
        ('150924', 4, '兴和县', '150900', '013650'),
        ('150925', 4, '凉城县', '150900', '013750'),
        ('150926', 4, '察哈尔右翼前旗', '150900', '012200'),
        ('150927', 4, '察哈尔右翼中旗', '150900', '013550'),
        ('150928', 4, '察哈尔右翼后旗', '150900', '012400'),
        ('150929', 4, '四子王旗', '150900', '011800'),
        ('150981', 4, '丰镇市', '150900', '012100'),
        ('150982', 4, '其它区', '150900', ''),
        ('152200', 3, '兴安盟', '150000', '137401'),
        ('152201', 4, '乌兰浩特市', '152200', '137400'),
        ('152202', 4, '阿尔山市', '152200', '137800'),
        ('152221', 4, '科尔沁右翼前旗', '152200', '137400'),
        ('152222', 4, '科尔沁右翼中旗', '152200', '029400'),
        ('152223', 4, '扎赉特旗', '152200', '137600'),
        ('152224', 4, '突泉县', '152200', '137500'),
        ('152225', 4, '其它区', '152200', ''),
        ('152500', 3, '锡林郭勒盟', '150000', '026021'),
        ('152501', 4, '二连浩特市', '152500', '011100'),
        ('152502', 4, '锡林浩特市', '152500', '026000'),
        ('152522', 4, '阿巴嘎旗', '152500', '011400'),
        ('152523', 4, '苏尼特左旗', '152500', '011300'),
        ('152524', 4, '苏尼特右旗', '152500', '011200'),
        ('152525', 4, '东乌珠穆沁旗', '152500', '026300'),
        ('152526', 4, '西乌珠穆沁旗', '152500', '026200'),
        ('152527', 4, '太仆寺旗', '152500', '027000'),
        ('152528', 4, '镶黄旗', '152500', '013250'),
        ('152529', 4, '正镶白旗', '152500', '013800'),
        ('152530', 4, '正蓝旗', '152500', '027200'),
        ('152531', 4, '多伦县', '152500', '027300'),
        ('152532', 4, '其它区', '152500', ''),
        ('152900', 3, '阿拉善盟', '150000', '750306'),
        ('152921', 4, '阿拉善左旗', '152900', '750300'),
        ('152922', 4, '阿拉善右旗', '152900', '737300'),
        ('152923', 4, '额济纳旗', '152900', '735400'),
        ('152924', 4, '其它区', '152900', ''),
        ('210000', 2, '辽宁省', '1', ''),
        ('210100', 3, '沈阳市', '210000', '110000'),
        ('210102', 4, '和平区', '210100', '110002'),
        ('210103', 4, '沈河区', '210100', '110013'),
        ('210104', 4, '大东区', '210100', '110044'),
        ('210105', 4, '皇姑区', '210100', '110031'),
        ('210106', 4, '铁西区', '210100', '110023'),
        ('210111', 4, '苏家屯区', '210100', '110102'),
        ('210112', 4, '东陵区', '210100', '110015'),
        ('210113', 4, '新城子区', '210100', '110121'),
        ('210114', 4, '于洪区', '210100', '110024'),
        ('210122', 4, '辽中县', '210100', '110200'),
        ('210123', 4, '康平县', '210100', '110500'),
        ('210124', 4, '法库县', '210100', '110400'),
        ('210181', 4, '新民市', '210100', '110300'),
        ('210182', 4, '浑南新区', '210100', ''),
        ('210183', 4, '张士开发区', '210100', ''),
        ('210184', 4, '沈北新区', '210100', ''),
        ('210185', 4, '其它区', '210100', ''),
        ('210200', 3, '大连市', '210000', '116000'),
        ('210202', 4, '中山区', '210200', '116001'),
        ('210203', 4, '西岗区', '210200', '116011'),
        ('210204', 4, '沙河口区', '210200', '116021'),
        ('210211', 4, '甘井子区', '210200', '116033'),
        ('210212', 4, '旅顺口区', '210200', '116041'),
        ('210213', 4, '金州区', '210200', '116100'),
        ('210224', 4, '长海县', '210200', '116500'),
        ('210251', 4, '开发区', '210200', ''),
        ('210281', 4, '瓦房店市', '210200', '116300'),
        ('210282', 4, '普兰店市', '210200', '116200'),
        ('210283', 4, '庄河市', '210200', '116400'),
        ('210297', 4, '岭前区', '210200', ''),
        ('210298', 4, '其它区', '210200', ''),
        ('210300', 3, '鞍山市', '210000', '114000'),
        ('210302', 4, '铁东区', '210300', '114001'),
        ('210303', 4, '铁西区', '210300', '110023'),
        ('210304', 4, '立山区', '210300', '114031'),
        ('210311', 4, '千山区', '210300', '114041'),
        ('210321', 4, '台安县', '210300', '114100'),
        ('210323', 4, '岫岩满族自治县', '210300', '114300'),
        ('210351', 4, '高新区', '210300', ''),
        ('210381', 4, '海城市', '210300', '114200'),
        ('210382', 4, '其它区', '210300', ''),
        ('210400', 3, '抚顺市', '210000', '113000'),
        ('210402', 4, '新抚区', '210400', '113006'),
        ('210403', 4, '东洲区', '210400', '113003'),
        ('210404', 4, '望花区', '210400', '113001'),
        ('210411', 4, '顺城区', '210400', '113006'),
        ('210421', 4, '抚顺县', '210400', '113100'),
        ('210422', 4, '新宾满族自治县', '210400', '113200'),
        ('210423', 4, '清原满族自治县', '210400', '113300'),
        ('210424', 4, '其它区', '210400', ''),
        ('210500', 3, '本溪市', '210000', '117000'),
        ('210502', 4, '平山区', '210500', '117000'),
        ('210503', 4, '溪湖区', '210500', '117002'),
        ('210504', 4, '明山区', '210500', '117021'),
        ('210505', 4, '南芬区', '210500', '117014'),
        ('210521', 4, '本溪满族自治县', '210500', '117100'),
        ('210522', 4, '桓仁满族自治县', '210500', '117200'),
        ('210523', 4, '其它区', '210500', ''),
        ('210600', 3, '丹东市', '210000', '118000'),
        ('210602', 4, '元宝区', '210600', '118000'),
        ('210603', 4, '振兴区', '210600', '118002'),
        ('210604', 4, '振安区', '210600', '118001'),
        ('210624', 4, '宽甸满族自治县', '210600', '118200'),
        ('210681', 4, '东港市', '210600', '118300'),
        ('210682', 4, '凤城市', '210600', '118100'),
        ('210683', 4, '其它区', '210600', ''),
        ('210700', 3, '锦州市', '210000', '121000'),
        ('210702', 4, '古塔区', '210700', '121001'),
        ('210703', 4, '凌河区', '210700', '121000'),
        ('210711', 4, '太和区', '210700', '121011'),
        ('210726', 4, '黑山县', '210700', '121400'),
        ('210727', 4, '义县', '210700', '121100'),
        ('210781', 4, '凌海市', '210700', '121200'),
        ('210782', 4, '北镇市', '210700', '121300'),
        ('210783', 4, '其它区', '210700', ''),
        ('210800', 3, '营口市', '210000', '115000'),
        ('210802', 4, '站前区', '210800', '115002'),
        ('210803', 4, '西市区', '210800', '115004'),
        ('210804', 4, '鲅鱼圈区', '210800', '115007'),
        ('210811', 4, '老边区', '210800', '115005'),
        ('210881', 4, '盖州市', '210800', '115200'),
        ('210882', 4, '大石桥市', '210800', '115100'),
        ('210883', 4, '其它区', '210800', ''),
        ('210900', 3, '阜新市', '210000', '123000'),
        ('210902', 4, '海州区', '210900', '123000'),
        ('210903', 4, '新邱区', '210900', '123005'),
        ('210904', 4, '太平区', '210900', '123003'),
        ('210905', 4, '清河门区', '210900', '123006'),
        ('210911', 4, '细河区', '210900', '123000'),
        ('210921', 4, '阜新蒙古族自治县', '210900', '123100'),
        ('210922', 4, '彰武县', '210900', '123200'),
        ('210923', 4, '其它区', '210900', ''),
        ('211000', 3, '辽阳市', '210000', '111000'),
        ('211002', 4, '白塔区', '211000', '111000'),
        ('211003', 4, '文圣区', '211000', '111000'),
        ('211004', 4, '宏伟区', '211000', '111003'),
        ('211005', 4, '弓长岭区', '211000', '111008'),
        ('211011', 4, '太子河区', '211000', '111000'),
        ('211021', 4, '辽阳县', '211000', '111200'),
        ('211081', 4, '灯塔市', '211000', '111300'),
        ('211082', 4, '其它区', '211000', ''),
        ('211100', 3, '盘锦市', '210000', '124000'),
        ('211102', 4, '双台子区', '211100', '124000'),
        ('211103', 4, '兴隆台区', '211100', '124010'),
        ('211121', 4, '大洼县', '211100', '124000'),
        ('211122', 4, '盘山县', '211100', '124100'),
        ('211123', 4, '其它区', '211100', ''),
        ('211200', 3, '铁岭市', '210000', '112000'),
        ('211202', 4, '银州区', '211200', '112000'),
        ('211204', 4, '清河区', '211200', '112003'),
        ('211221', 4, '铁岭县', '211200', '112600'),
        ('211223', 4, '西丰县', '211200', '112400'),
        ('211224', 4, '昌图县', '211200', '112500'),
        ('211281', 4, '调兵山市', '211200', '112700'),
        ('211282', 4, '开原市', '211200', '112300'),
        ('211283', 4, '其它区', '211200', ''),
        ('211300', 3, '朝阳市', '210000', '122000'),
        ('211302', 4, '双塔区', '211300', '122000'),
        ('211303', 4, '龙城区', '211300', '122000'),
        ('211321', 4, '朝阳县', '211300', '122000'),
        ('211322', 4, '建平县', '211300', '122400'),
        ('211324', 4, '喀喇沁左翼蒙古族自治县', '211300', '122300'),
        ('211381', 4, '北票市', '211300', '122100'),
        ('211382', 4, '凌源市', '211300', '122500'),
        ('211383', 4, '其它区', '211300', ''),
        ('211400', 3, '葫芦岛市', '210000', '125000'),
        ('211402', 4, '连山区', '211400', '125001'),
        ('211403', 4, '龙港区', '211400', '125004'),
        ('211404', 4, '南票区', '211400', '125027'),
        ('211421', 4, '绥中县', '211400', '125200'),
        ('211422', 4, '建昌县', '211400', '125300'),
        ('211481', 4, '兴城市', '211400', '125100'),
        ('211482', 4, '其它区', '211400', ''),
        ('220000', 2, '吉林省', '1', ''),
        ('220100', 3, '长春市', '220000', '130000'),
        ('220102', 4, '南关区', '220100', '130022'),
        ('220103', 4, '宽城区', '220100', '130051'),
        ('220104', 4, '朝阳区', '220100', '130012'),
        ('220105', 4, '二道区', '220100', '130031'),
        ('220106', 4, '绿园区', '220100', '130062'),
        ('220112', 4, '双阳区', '220100', '130600'),
        ('220122', 4, '农安县', '220100', '130200'),
        ('220181', 4, '九台市', '220100', '130500'),
        ('220182', 4, '榆树市', '220100', '130400'),
        ('220183', 4, '德惠市', '220100', '130300'),
        ('220184', 4, '高新技术产业开发区', '220100', ''),
        ('220185', 4, '汽车产业开发区', '220100', ''),
        ('220186', 4, '经济技术开发区', '220100', ''),
        ('220187', 4, '净月旅游开发区', '220100', ''),
        ('220188', 4, '其它区', '220100', ''),
        ('220200', 3, '吉林市', '220000', '132000'),
        ('220202', 4, '昌邑区', '220200', '132002'),
        ('220203', 4, '龙潭区', '220200', '132021'),
        ('220204', 4, '船营区', '220200', '132011'),
        ('220211', 4, '丰满区', '220200', '132113'),
        ('220221', 4, '永吉县', '220200', '132100'),
        ('220281', 4, '蛟河市', '220200', '132500'),
        ('220282', 4, '桦甸市', '220200', '132400'),
        ('220283', 4, '舒兰市', '220200', '132600'),
        ('220284', 4, '磐石市', '220200', '132300'),
        ('220285', 4, '其它区', '220200', ''),
        ('220300', 3, '四平市', '220000', '136000'),
        ('220302', 4, '铁西区', '220300', '136000'),
        ('220303', 4, '铁东区', '220300', '136001'),
        ('220322', 4, '梨树县', '220300', '136500'),
        ('220323', 4, '伊通满族自治县', '220300', '130700'),
        ('220381', 4, '公主岭市', '220300', '136100'),
        ('220382', 4, '双辽市', '220300', '136400'),
        ('220383', 4, '其它区', '220300', ''),
        ('220400', 3, '辽源市', '220000', '136200'),
        ('220402', 4, '龙山区', '220400', '136200'),
        ('220403', 4, '西安区', '220400', '136201'),
        ('220421', 4, '东丰县', '220400', '136300'),
        ('220422', 4, '东辽县', '220400', '136600'),
        ('220423', 4, '其它区', '220400', ''),
        ('220500', 3, '通化市', '220000', '134000'),
        ('220502', 4, '东昌区', '220500', '134001'),
        ('220503', 4, '二道江区', '220500', '134303'),
        ('220521', 4, '通化县', '220500', '134100'),
        ('220523', 4, '辉南县', '220500', '135100'),
        ('220524', 4, '柳河县', '220500', '135300'),
        ('220581', 4, '梅河口市', '220500', '135000'),
        ('220582', 4, '集安市', '220500', '134200'),
        ('220583', 4, '其它区', '220500', ''),
        ('220600', 3, '白山市', '220000', '134300'),
        ('220602', 4, '八道江区', '220600', '134300'),
        ('220621', 4, '抚松县', '220600', '134500'),
        ('220622', 4, '靖宇县', '220600', '135200'),
        ('220623', 4, '长白朝鲜族自治县', '220600', '134400'),
        ('220625', 4, '江源市', '220600', '134700'),
        ('220681', 4, '临江市', '220600', '134600'),
        ('220682', 4, '其它区', '220600', ''),
        ('220700', 3, '松原市', '220000', '138000'),
        ('220702', 4, '宁江区', '220700', '138000'),
        ('220721', 4, '前郭尔罗斯蒙古族自治县', '220700', '131100'),
        ('220722', 4, '长岭县', '220700', '131500'),
        ('220723', 4, '乾安县', '220700', '131400'),
        ('220724', 4, '扶余县', '220700', '131200'),
        ('220725', 4, '其它区', '220700', ''),
        ('220800', 3, '白城市', '220000', '137000'),
        ('220802', 4, '洮北区', '220800', '137000'),
        ('220821', 4, '镇赉县', '220800', '137300'),
        ('220822', 4, '通榆县', '220800', '137200'),
        ('220881', 4, '洮南市', '220800', '137100'),
        ('220882', 4, '大安市', '220800', '131300'),
        ('220883', 4, '其它区', '220800', ''),
        ('222400', 3, '延边朝鲜族自治州', '220000', '133000'),
        ('222401', 4, '延吉市', '222400', '133000'),
        ('222402', 4, '图们市', '222400', '133100'),
        ('222403', 4, '敦化市', '222400', '133700'),
        ('222404', 4, '珲春市', '222400', '133300'),
        ('222405', 4, '龙井市', '222400', '133400'),
        ('222406', 4, '和龙市', '222400', '133500'),
        ('222424', 4, '汪清县', '222400', '133200'),
        ('222426', 4, '安图县', '222400', '133600'),
        ('222427', 4, '其它区', '222400', ''),
        ('230000', 2, '黑龙江省', '1', ''),
        ('230100', 3, '哈尔滨市', '230000', '150000'),
        ('230102', 4, '道里区', '230100', '150010'),
        ('230103', 4, '南岗区', '230100', '150006'),
        ('230104', 4, '道外区', '230100', '150026'),
        ('230106', 4, '香坊区', '230100', '150036'),
        ('230107', 4, '动力区', '230100', '150040'),
        ('230108', 4, '平房区', '230100', '150060'),
        ('230109', 4, '松北区', '230100', '150028'),
        ('230111', 4, '呼兰区', '230100', '150500'),
        ('230123', 4, '依兰县', '230100', '154800'),
        ('230124', 4, '方正县', '230100', '150800'),
        ('230125', 4, '宾县', '230100', '150400'),
        ('230126', 4, '巴彦县', '230100', '151800'),
        ('230127', 4, '木兰县', '230100', '151900'),
        ('230128', 4, '通河县', '230100', '150900'),
        ('230129', 4, '延寿县', '230100', '150700'),
        ('230181', 4, '阿城市', '230100', '150300'),
        ('230182', 4, '双城市', '230100', '150100'),
        ('230183', 4, '尚志市', '230100', '150600'),
        ('230184', 4, '五常市', '230100', '150200'),
        ('230185', 4, '阿城市', '230100', '150300'),
        ('230186', 4, '其它区', '230100', ''),
        ('230200', 3, '齐齐哈尔市', '230000', '161000'),
        ('230202', 4, '龙沙区', '230200', '161000'),
        ('230203', 4, '建华区', '230200', '161006'),
        ('230204', 4, '铁锋区', '230200', '161000'),
        ('230205', 4, '昂昂溪区', '230200', '161031'),
        ('230206', 4, '富拉尔基区', '230200', '161041'),
        ('230207', 4, '碾子山区', '230200', '161046'),
        ('230208', 4, '梅里斯达斡尔族区', '230200', '161021'),
        ('230221', 4, '龙江县', '230200', '161100'),
        ('230223', 4, '依安县', '230200', '161500'),
        ('230224', 4, '泰来县', '230200', '162400'),
        ('230225', 4, '甘南县', '230200', '162100'),
        ('230227', 4, '富裕县', '230200', '161200'),
        ('230229', 4, '克山县', '230200', '161600'),
        ('230230', 4, '克东县', '230200', '164800'),
        ('230231', 4, '拜泉县', '230200', '164700'),
        ('230281', 4, '讷河市', '230200', '161300'),
        ('230282', 4, '其它区', '230200', ''),
        ('230300', 3, '鸡西市', '230000', '158100'),
        ('230302', 4, '鸡冠区', '230300', '158100'),
        ('230303', 4, '恒山区', '230300', '158130'),
        ('230304', 4, '滴道区', '230300', '158150'),
        ('230305', 4, '梨树区', '230300', '158160'),
        ('230306', 4, '城子河区', '230300', '158170'),
        ('230307', 4, '麻山区', '230300', '158180'),
        ('230321', 4, '鸡东县', '230300', '158200'),
        ('230381', 4, '虎林市', '230300', '158400'),
        ('230382', 4, '密山市', '230300', '158300'),
        ('230383', 4, '其它区', '230300', ''),
        ('230400', 3, '鹤岗市', '230000', '154100'),
        ('230402', 4, '向阳区', '230400', '154100'),
        ('230403', 4, '工农区', '230400', '154101'),
        ('230404', 4, '南山区', '230400', '154104'),
        ('230405', 4, '兴安区', '230400', '154102'),
        ('230406', 4, '东山区', '230400', '154106'),
        ('230407', 4, '兴山区', '230400', '154105'),
        ('230421', 4, '萝北县', '230400', '154200'),
        ('230422', 4, '绥滨县', '230400', '156200'),
        ('230423', 4, '其它区', '230400', ''),
        ('230500', 3, '双鸭山市', '230000', '155100'),
        ('230502', 4, '尖山区', '230500', '155100'),
        ('230503', 4, '岭东区', '230500', '155120'),
        ('230505', 4, '四方台区', '230500', '155130'),
        ('230506', 4, '宝山区', '230500', '155131'),
        ('230521', 4, '集贤县', '230500', '155900'),
        ('230522', 4, '友谊县', '230500', '155800'),
        ('230523', 4, '宝清县', '230500', '155600'),
        ('230524', 4, '饶河县', '230500', '155700'),
        ('230525', 4, '其它区', '230500', ''),
        ('230600', 3, '大庆市', '230000', '163000'),
        ('230602', 4, '萨尔图区', '230600', '163311'),
        ('230603', 4, '龙凤区', '230600', '163711'),
        ('230604', 4, '让胡路区', '230600', '163453'),
        ('230605', 4, '红岗区', '230600', '163512'),
        ('230606', 4, '大同区', '230600', '163814'),
        ('230621', 4, '肇州县', '230600', '166400'),
        ('230622', 4, '肇源县', '230600', '166500'),
        ('230623', 4, '林甸县', '230600', '166300'),
        ('230624', 4, '杜尔伯特蒙古族自治县', '230600', '166200'),
        ('230625', 4, '其它区', '230600', ''),
        ('230700', 3, '伊春市', '230000', '153000'),
        ('230702', 4, '伊春区', '230700', '153000'),
        ('230703', 4, '南岔区', '230700', '153100'),
        ('230704', 4, '友好区', '230700', '153031'),
        ('230705', 4, '西林区', '230700', '153025'),
        ('230706', 4, '翠峦区', '230700', '153013'),
        ('230707', 4, '新青区', '230700', '153036'),
        ('230708', 4, '美溪区', '230700', '153021'),
        ('230709', 4, '金山屯区', '230700', '152026'),
        ('230710', 4, '五营区', '230700', '153033'),
        ('230711', 4, '乌马河区', '230700', '153011'),
        ('230712', 4, '汤旺河区', '230700', '153037'),
        ('230713', 4, '带岭区', '230700', '153106'),
        ('230714', 4, '乌伊岭区', '230700', '153038'),
        ('230715', 4, '红星区', '230700', '153035'),
        ('230716', 4, '上甘岭区', '230700', '153032'),
        ('230722', 4, '嘉荫县', '230700', '153200'),
        ('230781', 4, '铁力市', '230700', '152500'),
        ('230782', 4, '其它区', '230700', ''),
        ('230800', 3, '佳木斯市', '230000', '154000'),
        ('230802', 4, '永红区', '230800', '154003'),
        ('230803', 4, '向阳区', '230800', '154002'),
        ('230804', 4, '前进区', '230800', '154002'),
        ('230805', 4, '东风区', '230800', '154005'),
        ('230811', 4, '郊区', '230800', '154004'),
        ('230822', 4, '桦南县', '230800', '154400'),
        ('230826', 4, '桦川县', '230800', '154300'),
        ('230828', 4, '汤原县', '230800', '154700'),
        ('230833', 4, '抚远县', '230800', '156500'),
        ('230881', 4, '同江市', '230800', '156400'),
        ('230882', 4, '富锦市', '230800', '156100'),
        ('230883', 4, '其它区', '230800', ''),
        ('230900', 3, '七台河市', '230000', '154600'),
        ('230902', 4, '新兴区', '230900', '154604'),
        ('230903', 4, '桃山区', '230900', '154600'),
        ('230904', 4, '茄子河区', '230900', '154622'),
        ('230921', 4, '勃利县', '230900', '154500'),
        ('230922', 4, '其它区', '230900', ''),
        ('231000', 3, '牡丹江市', '230000', '157000'),
        ('231002', 4, '东安区', '231000', '157000'),
        ('231003', 4, '阳明区', '231000', '157013'),
        ('231004', 4, '爱民区', '231000', '157009'),
        ('231005', 4, '西安区', '231000', '157000'),
        ('231024', 4, '东宁县', '231000', '157200'),
        ('231025', 4, '林口县', '231000', '157600'),
        ('231081', 4, '绥芬河市', '231000', '157300'),
        ('231083', 4, '海林市', '231000', '157100'),
        ('231084', 4, '宁安市', '231000', '157400'),
        ('231085', 4, '穆棱市', '231000', '157500'),
        ('231086', 4, '其它区', '231000', ''),
        ('231100', 3, '黑河市', '230000', '164300'),
        ('231102', 4, '爱辉区', '231100', '164300'),
        ('231121', 4, '嫩江县', '231100', '161400'),
        ('231123', 4, '逊克县', '231100', '164400'),
        ('231124', 4, '孙吴县', '231100', '164200'),
        ('231181', 4, '北安市', '231100', '164000'),
        ('231182', 4, '五大连池市', '231100', '164100'),
        ('231183', 4, '其它区', '231100', ''),
        ('231200', 3, '绥化市', '230000', '152000'),
        ('231202', 4, '北林区', '231200', '152000'),
        ('231221', 4, '望奎县', '231200', '152100'),
        ('231222', 4, '兰西县', '231200', '151500'),
        ('231223', 4, '青冈县', '231200', '151600'),
        ('231224', 4, '庆安县', '231200', '152400'),
        ('231225', 4, '明水县', '231200', '151700'),
        ('231226', 4, '绥棱县', '231200', '152200'),
        ('231281', 4, '安达市', '231200', '151400'),
        ('231282', 4, '肇东市', '231200', '151100'),
        ('231283', 4, '海伦市', '231200', '152300'),
        ('231284', 4, '其它区', '231200', ''),
        ('232700', 3, '大兴安岭地区', '230000', '165000'),
        ('232721', 4, '呼玛县', '232700', '165100'),
        ('232722', 4, '塔河县', '232700', '165200'),
        ('232723', 4, '漠河县', '232700', '\r\n165300'),
        ('232724', 4, '加格达奇区', '232700', '165300'),
        ('232725', 4, '其它区', '232700', ''),
        ('310000', 2, '上海', '1', ''),
        ('310100', 3, '上海市', '310000', '200000'),
        ('310101', 4, '黄浦区', '310100', '200001'),
        ('310103', 4, '卢湾区', '310100', '200020'),
        ('310104', 4, '徐汇区', '310100', '200030'),
        ('310105', 4, '长宁区', '310100', '200050'),
        ('310106', 4, '静安区', '310100', '200040'),
        ('310107', 4, '普陀区', '310100', '200062'),
        ('310108', 4, '闸北区', '310100', '200070'),
        ('310109', 4, '虹口区', '310100', '200080'),
        ('310110', 4, '杨浦区', '310100', '200082'),
        ('310112', 4, '闵行区', '310100', '201100'),
        ('310113', 4, '宝山区', '310100', '201900'),
        ('310114', 4, '嘉定区', '310100', '201800'),
        ('310115', 4, '浦东新区', '310100', '200120'),
        ('310116', 4, '金山区', '310100', '201540'),
        ('310117', 4, '松江区', '310100', '201600'),
        ('310118', 4, '青浦区', '310100', '201700'),
        ('310119', 4, '南汇区', '310100', '201300'),
        ('310120', 4, '奉贤区', '310100', '201400'),
        ('310152', 4, '川沙区', '310100', ''),
        ('310230', 4, '崇明县', '310100', '202150'),
        ('310231', 4, '其它区', '310100', ''),
        ('320000', 2, '江苏省', '1', ''),
        ('320100', 3, '南京市', '320000', '210000'),
        ('320102', 4, '玄武区', '320100', '210018'),
        ('320103', 4, '白下区', '320100', '210002'),
        ('320104', 4, '秦淮区', '320100', '210001'),
        ('320105', 4, '建邺区', '320100', '210004'),
        ('320106', 4, '鼓楼区', '320100', '210009'),
        ('320107', 4, '下关区', '320100', '210011'),
        ('320111', 4, '浦口区', '320100', '211800'),
        ('320113', 4, '栖霞区', '320100', '210046'),
        ('320114', 4, '雨花台区', '320100', '210012'),
        ('320115', 4, '江宁区', '320100', '211100'),
        ('320116', 4, '六合区', '320100', '211500'),
        ('320124', 4, '溧水县', '320100', '211200'),
        ('320125', 4, '高淳县', '320100', '211300'),
        ('320126', 4, '其它区', '320100', ''),
        ('320200', 3, '无锡市', '320000', '214000'),
        ('320202', 4, '崇安区', '320200', '214002'),
        ('320203', 4, '南长区', '320200', '214021'),
        ('320204', 4, '北塘区', '320200', '214044'),
        ('320205', 4, '锡山区', '320200', '214101'),
        ('320206', 4, '惠山区', '320200', '214187'),
        ('320211', 4, '滨湖区', '320200', '214062'),
        ('320281', 4, '江阴市', '320200', '214400'),
        ('320282', 4, '宜兴市', '320200', '214200'),
        ('320296', 4, '新区', '320200', ''),
        ('320297', 4, '其它区', '320200', ''),
        ('320300', 3, '徐州市', '320000', '221000'),
        ('320302', 4, '鼓楼区', '320300', '220005'),
        ('320303', 4, '云龙区', '320300', '220009'),
        ('320304', 4, '九里区', '320300', '220040'),
        ('320305', 4, '贾汪区', '320300', '220011'),
        ('320311', 4, '泉山区', '320300', '220006'),
        ('320321', 4, '丰县', '320300', '221700'),
        ('320322', 4, '沛县', '320300', '221600'),
        ('320323', 4, '铜山县', '320300', '221112'),
        ('320324', 4, '睢宁县', '320300', '221200'),
        ('320381', 4, '新沂市', '320300', '221400'),
        ('320382', 4, '邳州市', '320300', '221300'),
        ('320383', 4, '其它区', '320300', ''),
        ('320400', 3, '常州市', '320000', '213000'),
        ('320402', 4, '天宁区', '320400', '213003'),
        ('320404', 4, '钟楼区', '320400', '213002'),
        ('320405', 4, '戚墅堰区', '320400', '213011'),
        ('320411', 4, '新北区', '320400', '213001'),
        ('320412', 4, '武进区', '320400', '213161'),
        ('320481', 4, '溧阳市', '320400', '213300'),
        ('320482', 4, '金坛市', '320400', '213200'),
        ('320483', 4, '其它区', '320400', ''),
        ('320500', 3, '苏州市', '320000', '215000'),
        ('320502', 4, '沧浪区', '320500', '215006'),
        ('320503', 4, '平江区', '320500', '215005'),
        ('320504', 4, '金阊区', '320500', '215008'),
        ('320505', 4, '虎丘区', '320500', '215004'),
        ('320506', 4, '吴中区', '320500', '215128'),
        ('320507', 4, '相城区', '320500', '215131'),
        ('320581', 4, '常熟市', '320500', '215500'),
        ('320582', 4, '张家港市', '320500', '215600'),
        ('320583', 4, '昆山市', '320500', '215300'),
        ('320584', 4, '吴江市', '320500', '215200'),
        ('320585', 4, '太仓市', '320500', '215400'),
        ('320594', 4, '新区', '320500', ''),
        ('320595', 4, '园区', '320500', ''),
        ('320596', 4, '其它区', '320500', ''),
        ('320600', 3, '南通市', '320000', '226000'),
        ('320602', 4, '崇川区', '320600', '226001'),
        ('320611', 4, '港闸区', '320600', '226001'),
        ('320612', 4, '通州区', '320600', '226321'),
        ('320621', 4, '海安县', '320600', '226600'),
        ('320623', 4, '如东县', '320600', '226400'),
        ('320681', 4, '启东市', '320600', '226200'),
        ('320682', 4, '如皋市', '320600', '226500'),
        ('320683', 4, '通州市', '320600', '226300'),
        ('320684', 4, '海门市', '320600', '226100'),
        ('320693', 4, '开发区', '320600', ''),
        ('320694', 4, '其它区', '320600', ''),
        ('320700', 3, '连云港市', '320000', '222000'),
        ('320703', 4, '连云区', '320700', '222042'),
        ('320705', 4, '新浦区', '320700', '222003'),
        ('320706', 4, '海州区', '320700', '222023'),
        ('320721', 4, '赣榆县', '320700', '222100'),
        ('320722', 4, '东海县', '320700', '222300'),
        ('320723', 4, '灌云县', '320700', '222200'),
        ('320724', 4, '灌南县', '320700', '222500'),
        ('320725', 4, '其它区', '320700', ''),
        ('320800', 3, '淮安市', '320000', '223200'),
        ('320802', 4, '清河区', '320800', '223001'),
        ('320803', 4, '楚州区', '320800', '223200'),
        ('320804', 4, '淮阴区', '320800', '223000'),
        ('320811', 4, '清浦区', '320800', '223002'),
        ('320826', 4, '涟水县', '320800', '223400'),
        ('320829', 4, '洪泽县', '320800', '223100'),
        ('320830', 4, '盱眙县', '320800', '211700'),
        ('320831', 4, '金湖县', '320800', '211600'),
        ('320832', 4, '其它区', '320800', ''),
        ('320900', 3, '盐城市', '320000', '224000'),
        ('320902', 4, '亭湖区', '320900', '224005'),
        ('320903', 4, '盐都区', '320900', '224055'),
        ('320921', 4, '响水县', '320900', '224600'),
        ('320922', 4, '滨海县', '320900', '224500'),
        ('320923', 4, '阜宁县', '320900', '224400'),
        ('320924', 4, '射阳县', '320900', '224300'),
        ('320925', 4, '建湖县', '320900', '224700'),
        ('320981', 4, '东台市', '320900', '224200'),
        ('320982', 4, '大丰市', '320900', '224100'),
        ('320983', 4, '其它区', '320900', ''),
        ('321000', 3, '扬州市', '320000', '225000'),
        ('321002', 4, '广陵区', '321000', '225002'),
        ('321003', 4, '邗江区', '321000', '225100'),
        ('321011', 4, '维扬区', '321000', '225002'),
        ('321023', 4, '宝应县', '321000', '225800'),
        ('321081', 4, '仪征市', '321000', '211400'),
        ('321084', 4, '高邮市', '321000', '225600'),
        ('321088', 4, '江都市', '321000', '225200'),
        ('321092', 4, '经济开发区', '321000', ''),
        ('321093', 4, '其它区', '321000', ''),
        ('321100', 3, '镇江市', '320000', '212000'),
        ('321102', 4, '京口区', '321100', '212001'),
        ('321111', 4, '润州区', '321100', '212004'),
        ('321112', 4, '丹徒区', '321100', '212001'),
        ('321181', 4, '丹阳市', '321100', '212300'),
        ('321182', 4, '扬中市', '321100', '212200'),
        ('321183', 4, '句容市', '321100', '212400'),
        ('321184', 4, '其它区', '321100', ''),
        ('321200', 3, '泰州市', '320000', '225300'),
        ('321202', 4, '海陵区', '321200', '225300'),
        ('321203', 4, '高港区', '321200', '225321'),
        ('321281', 4, '兴化市', '321200', '225700'),
        ('321282', 4, '靖江市', '321200', '214500'),
        ('321283', 4, '泰兴市', '321200', '225400'),
        ('321284', 4, '姜堰市', '321200', '225500'),
        ('321285', 4, '其它区', '321200', ''),
        ('321300', 3, '宿迁市', '320000', '223800'),
        ('321302', 4, '宿城区', '321300', '223800'),
        ('321311', 4, '宿豫区', '321300', '223800'),
        ('321322', 4, '沭阳县', '321300', '223600'),
        ('321323', 4, '泗阳县', '321300', '223700'),
        ('321324', 4, '泗洪县', '321300', '223900'),
        ('321325', 4, '其它区', '321300', ''),
        ('330000', 2, '浙江省', '1', ''),
        ('330100', 3, '杭州市', '330000', '310000'),
        ('330102', 4, '上城区', '330100', '311500'),
        ('330103', 4, '下城区', '330100', '310006'),
        ('330104', 4, '江干区', '330100', '310002'),
        ('330105', 4, '拱墅区', '330100', '310011'),
        ('330106', 4, '西湖区', '330100', '310013'),
        ('330108', 4, '滨江区', '330100', '310051'),
        ('330109', 4, '萧山区', '330100', '311200'),
        ('330110', 4, '余杭区', '330100', '311100'),
        ('330122', 4, '桐庐县', '330100', '311500'),
        ('330127', 4, '淳安县', '330100', '311700'),
        ('330182', 4, '建德市', '330100', '311600'),
        ('330183', 4, '富阳市', '330100', '311400'),
        ('330185', 4, '临安市', '330100', '311300'),
        ('330186', 4, '其它区', '330100', ''),
        ('330200', 3, '宁波市', '330000', '315000'),
        ('330203', 4, '海曙区', '330200', '315000'),
        ('330204', 4, '江东区', '330200', '315040'),
        ('330205', 4, '江北区', '330200', '315020'),
        ('330206', 4, '北仑区', '330200', '315800'),
        ('330211', 4, '镇海区', '330200', '315200'),
        ('330212', 4, '鄞州区', '330200', '315100'),
        ('330225', 4, '象山县', '330200', '315700'),
        ('330226', 4, '宁海县', '330200', '315600'),
        ('330281', 4, '余姚市', '330200', '315400'),
        ('330282', 4, '慈溪市', '330200', '315300'),
        ('330283', 4, '奉化市', '330200', '315500'),
        ('330284', 4, '其它区', '330200', ''),
        ('330300', 3, '温州市', '330000', '325000'),
        ('330302', 4, '鹿城区', '330300', '325000');
        INSERT INTO {{%area_code}} (`id`, `type`, `name`, `parent_id`, `zip`) VALUES
        ('330303', 4, '龙湾区', '330300', '325024'),
        ('330304', 4, '瓯海区', '330300', '325005'),
        ('330322', 4, '洞头县', '330300', '325700'),
        ('330324', 4, '永嘉县', '330300', '325100'),
        ('330326', 4, '平阳县', '330300', '325400'),
        ('330327', 4, '苍南县', '330300', '325800'),
        ('330328', 4, '文成县', '330300', '325300'),
        ('330329', 4, '泰顺县', '330300', '325500'),
        ('330381', 4, '瑞安市', '330300', '325200'),
        ('330382', 4, '乐清市', '330300', '325600'),
        ('330383', 4, '其它区', '330300', ''),
        ('330400', 3, '嘉兴市', '330000', '314000'),
        ('330402', 4, '南湖区', '330400', '314000'),
        ('330411', 4, '秀洲区', '330400', '314001'),
        ('330421', 4, '嘉善县', '330400', '314100'),
        ('330424', 4, '海盐县', '330400', '314300'),
        ('330481', 4, '海宁市', '330400', '314400'),
        ('330482', 4, '平湖市', '330400', '314200'),
        ('330483', 4, '桐乡市', '330400', '314500'),
        ('330484', 4, '其它区', '330400', ''),
        ('330500', 3, '湖州市', '330000', '313000'),
        ('330502', 4, '吴兴区', '330500', '313000'),
        ('330503', 4, '南浔区', '330500', '313009'),
        ('330521', 4, '德清县', '330500', '313200'),
        ('330522', 4, '长兴县', '330500', '313100'),
        ('330523', 4, '安吉县', '330500', '313300'),
        ('330524', 4, '其它区', '330500', ''),
        ('330600', 3, '绍兴市', '330000', '312000'),
        ('330602', 4, '越城区', '330600', '312000'),
        ('330621', 4, '绍兴县', '330600', '312000'),
        ('330624', 4, '新昌县', '330600', '312500'),
        ('330681', 4, '诸暨市', '330600', '311800'),
        ('330682', 4, '上虞市', '330600', '312300'),
        ('330683', 4, '嵊州市', '330600', '312400'),
        ('330684', 4, '其它区', '330600', ''),
        ('330700', 3, '金华市', '330000', '321000'),
        ('330702', 4, '婺城区', '330700', '321051'),
        ('330703', 4, '金东区', '330700', '321002'),
        ('330723', 4, '武义县', '330700', '321200'),
        ('330726', 4, '浦江县', '330700', '322200'),
        ('330727', 4, '磐安县', '330700', '322300'),
        ('330781', 4, '兰溪市', '330700', '321100'),
        ('330782', 4, '义乌市', '330700', '322000'),
        ('330783', 4, '东阳市', '330700', '322100'),
        ('330784', 4, '永康市', '330700', '321300'),
        ('330785', 4, '其它区', '330700', ''),
        ('330800', 3, '衢州市', '330000', '324000'),
        ('330802', 4, '柯城区', '330800', '324000'),
        ('330803', 4, '衢江区', '330800', '324000'),
        ('330822', 4, '常山县', '330800', '324200'),
        ('330824', 4, '开化县', '330800', '324300'),
        ('330825', 4, '龙游县', '330800', '324400'),
        ('330881', 4, '江山市', '330800', '324100'),
        ('330882', 4, '其它区', '330800', ''),
        ('330900', 3, '舟山市', '330000', '316000'),
        ('330902', 4, '定海区', '330900', '316000'),
        ('330903', 4, '普陀区', '330900', '316100'),
        ('330921', 4, '岱山县', '330900', '316200'),
        ('330922', 4, '嵊泗县', '330900', '202400'),
        ('330923', 4, '其它区', '330900', ''),
        ('331000', 3, '台州市', '330000', '318000'),
        ('331002', 4, '椒江区', '331000', '318000'),
        ('331003', 4, '黄岩区', '331000', '318020'),
        ('331004', 4, '路桥区', '331000', '318050'),
        ('331021', 4, '玉环县', '331000', '317600'),
        ('331022', 4, '三门县', '331000', '317100'),
        ('331023', 4, '天台县', '331000', '317200'),
        ('331024', 4, '仙居县', '331000', '317300'),
        ('331081', 4, '温岭市', '331000', '317500'),
        ('331082', 4, '临海市', '331000', '317000'),
        ('331083', 4, '其它区', '331000', ''),
        ('331100', 3, '丽水市', '330000', '323000'),
        ('331102', 4, '莲都区', '331100', '323000'),
        ('331121', 4, '青田县', '331100', '323900'),
        ('331122', 4, '缙云县', '331100', '321400'),
        ('331123', 4, '遂昌县', '331100', '323300'),
        ('331124', 4, '松阳县', '331100', '323400'),
        ('331125', 4, '云和县', '331100', '323600'),
        ('331126', 4, '庆元县', '331100', '323800'),
        ('331127', 4, '景宁畲族自治县', '331100', '323500'),
        ('331181', 4, '龙泉市', '331100', '323700'),
        ('331182', 4, '其它区', '331100', ''),
        ('340000', 2, '安徽省', '1', ''),
        ('340100', 3, '合肥市', '340000', '230000'),
        ('340102', 4, '瑶海区', '340100', '230011'),
        ('340103', 4, '庐阳区', '340100', '230001'),
        ('340104', 4, '蜀山区', '340100', '230061'),
        ('340111', 4, '包河区', '340100', '230041'),
        ('340121', 4, '长丰县', '340100', '231100'),
        ('340122', 4, '肥东县', '340100', '231600'),
        ('340123', 4, '肥西县', '340100', '231200'),
        ('340151', 4, '高新区', '340100', ''),
        ('340191', 4, '中区', '340100', ''),
        ('340192', 4, '其它区', '340100', ''),
        ('340200', 3, '芜湖市', '340000', '241000'),
        ('340202', 4, '镜湖区', '340200', '241000'),
        ('340203', 4, '弋江区', '340200', '241000'),
        ('340207', 4, '鸠江区', '340200', '241000'),
        ('340208', 4, '三山区', '340200', '241000'),
        ('340221', 4, '芜湖县', '340200', '241100'),
        ('340222', 4, '繁昌县', '340200', '241200'),
        ('340223', 4, '南陵县', '340200', '242400'),
        ('340224', 4, '其它区', '340200', ''),
        ('340300', 3, '蚌埠市', '340000', '233000'),
        ('340302', 4, '龙子湖区', '340300', '233000'),
        ('340303', 4, '蚌山区', '340300', '233000'),
        ('340304', 4, '禹会区', '340300', '233010'),
        ('340311', 4, '淮上区', '340300', '233002'),
        ('340321', 4, '怀远县', '340300', '233400'),
        ('340322', 4, '五河县', '340300', '233300'),
        ('340323', 4, '固镇县', '340300', '233200'),
        ('340324', 4, '其它区', '340300', ''),
        ('340400', 3, '淮南市', '340000', '232000'),
        ('340402', 4, '大通区', '340400', '232033'),
        ('340403', 4, '田家庵区', '340400', '232000'),
        ('340404', 4, '谢家集区', '340400', '232052'),
        ('340405', 4, '八公山区', '340400', '232072'),
        ('340406', 4, '潘集区', '340400', '232082'),
        ('340421', 4, '凤台县', '340400', '232100'),
        ('340422', 4, '其它区', '340400', ''),
        ('340500', 3, '马鞍山市', '340000', '243000'),
        ('340502', 4, '金家庄区', '340500', '243021'),
        ('340503', 4, '花山区', '340500', '243000'),
        ('340504', 4, '雨山区', '340500', '243071'),
        ('340521', 4, '当涂县', '340500', '243100'),
        ('340522', 4, '其它区', '340500', ''),
        ('340600', 3, '淮北市', '340000', '235000'),
        ('340602', 4, '杜集区', '340600', '235047'),
        ('340603', 4, '相山区', '340600', '235000'),
        ('340604', 4, '烈山区', '340600', '235025'),
        ('340621', 4, '濉溪县', '340600', '235100'),
        ('340622', 4, '其它区', '340600', ''),
        ('340700', 3, '铜陵市', '340000', '244000'),
        ('340702', 4, '铜官山区', '340700', '244000'),
        ('340703', 4, '狮子山区', '340700', '244031'),
        ('340711', 4, '郊区', '340700', '244000'),
        ('340721', 4, '铜陵县', '340700', '244100'),
        ('340722', 4, '其它区', '340700', ''),
        ('340800', 3, '安庆市', '340000', '246000'),
        ('340802', 4, '迎江区', '340800', '246003'),
        ('340803', 4, '大观区', '340800', '246004'),
        ('340811', 4, '宜秀区', '340800', '246003'),
        ('340822', 4, '怀宁县', '340800', '246100'),
        ('340823', 4, '枞阳县', '340800', '246700'),
        ('340824', 4, '潜山县', '340800', '246300'),
        ('340825', 4, '太湖县', '340800', '246400'),
        ('340826', 4, '宿松县', '340800', '246500'),
        ('340827', 4, '望江县', '340800', '246200'),
        ('340828', 4, '岳西县', '340800', '246600'),
        ('340881', 4, '桐城市', '340800', '231400'),
        ('340882', 4, '其它区', '340800', ''),
        ('341000', 3, '黄山市', '340000', '245000'),
        ('341002', 4, '屯溪区', '341000', '245000'),
        ('341003', 4, '黄山区', '341000', '242700'),
        ('341004', 4, '徽州区', '341000', '245061'),
        ('341021', 4, '歙县', '341000', '245200'),
        ('341022', 4, '休宁县', '341000', '245400'),
        ('341023', 4, '黟县', '341000', '245500'),
        ('341024', 4, '祁门县', '341000', '245600'),
        ('341025', 4, '其它区', '341000', ''),
        ('341100', 3, '滁州市', '340000', '239000'),
        ('341102', 4, '琅琊区', '341100', '239000'),
        ('341103', 4, '南谯区', '341100', '239000'),
        ('341122', 4, '来安县', '341100', '239200'),
        ('341124', 4, '全椒县', '341100', '239500'),
        ('341125', 4, '定远县', '341100', '233200'),
        ('341126', 4, '凤阳县', '341100', '233100'),
        ('341181', 4, '天长市', '341100', '239300'),
        ('341182', 4, '明光市', '341100', '239400'),
        ('341183', 4, '其它区', '341100', ''),
        ('341200', 3, '阜阳市', '340000', '236000'),
        ('341202', 4, '颍州区', '341200', '236001'),
        ('341203', 4, '颍东区', '341200', '236058'),
        ('341204', 4, '颍泉区', '341200', '236045'),
        ('341221', 4, '临泉县', '341200', '236400'),
        ('341222', 4, '太和县', '341200', '236600'),
        ('341225', 4, '阜南县', '341200', '236300'),
        ('341226', 4, '颍上县', '341200', '236200'),
        ('341282', 4, '界首市', '341200', '236500'),
        ('341283', 4, '其它区', '341200', ''),
        ('341300', 3, '宿州市', '340000', '234000'),
        ('341302', 4, '埇桥区', '341300', '234000'),
        ('341321', 4, '砀山县', '341300', '235300'),
        ('341322', 4, '萧县', '341300', '235200'),
        ('341323', 4, '灵璧县', '341300', '234200'),
        ('341324', 4, '泗县', '341300', '234300'),
        ('341325', 4, '其它区', '341300', ''),
        ('341400', 4, '巢湖市', '340100', '238000'),
        ('341402', 4, '居巢区', '340100', '238000'),
        ('341421', 4, '庐江县', '340100', '231500'),
        ('341422', 4, '无为县', '340200', '238300'),
        ('341423', 4, '含山县', '340500', '238100'),
        ('341424', 4, '和县', '340500', '238200'),
        ('341500', 3, '六安市', '340000', '237000'),
        ('341502', 4, '金安区', '341500', '237005'),
        ('341503', 4, '裕安区', '341500', '237010'),
        ('341521', 4, '寿县', '341500', '232200'),
        ('341522', 4, '霍邱县', '341500', '237400'),
        ('341523', 4, '舒城县', '341500', '231300'),
        ('341524', 4, '金寨县', '341500', '237300'),
        ('341525', 4, '霍山县', '341500', '237200'),
        ('341526', 4, '其它区', '341500', ''),
        ('341600', 3, '亳州市', '340000', '236800'),
        ('341602', 4, '谯城区', '341600', '236800'),
        ('341621', 4, '涡阳县', '341600', '233600'),
        ('341622', 4, '蒙城县', '341600', '233500'),
        ('341623', 4, '利辛县', '341600', '236700'),
        ('341624', 4, '其它区', '341600', ''),
        ('341700', 3, '池州市', '340000', '247000'),
        ('341702', 4, '贵池区', '341700', '247100'),
        ('341721', 4, '东至县', '341700', '247200'),
        ('341722', 4, '石台县', '341700', '245100'),
        ('341723', 4, '青阳县', '341700', '242800'),
        ('341724', 4, '其它区', '341700', ''),
        ('341800', 3, '宣城市', '340000', '242000'),
        ('341802', 4, '宣州区', '341800', '242000'),
        ('341821', 4, '郎溪县', '341800', '242100'),
        ('341822', 4, '广德县', '341800', '242200'),
        ('341823', 4, '泾县', '341800', '242500'),
        ('341824', 4, '绩溪县', '341800', '245300'),
        ('341825', 4, '旌德县', '341800', '242600'),
        ('341881', 4, '宁国市', '341800', '242300'),
        ('341882', 4, '其它区', '341800', ''),
        ('350000', 2, '福建省', '1', ''),
        ('350100', 3, '福州市', '350000', '350000'),
        ('350102', 4, '鼓楼区', '350100', '350001'),
        ('350103', 4, '台江区', '350100', '350004'),
        ('350104', 4, '仓山区', '350100', '350007'),
        ('350105', 4, '马尾区', '350100', '350015'),
        ('350111', 4, '晋安区', '350100', '350011'),
        ('350121', 4, '闽侯县', '350100', '350100'),
        ('350122', 4, '连江县', '350100', '350500'),
        ('350123', 4, '罗源县', '350100', '350600'),
        ('350124', 4, '闽清县', '350100', '350800'),
        ('350125', 4, '永泰县', '350100', '350700'),
        ('350128', 4, '平潭县', '350100', '350400'),
        ('350181', 4, '福清市', '350100', '350300'),
        ('350182', 4, '长乐市', '350100', '350200'),
        ('350183', 4, '其它区', '350100', ''),
        ('350200', 3, '厦门市', '350000', '361000'),
        ('350203', 4, '思明区', '350200', '361001'),
        ('350205', 4, '海沧区', '350200', '361026'),
        ('350206', 4, '湖里区', '350200', '361006'),
        ('350211', 4, '集美区', '350200', '361021'),
        ('350212', 4, '同安区', '350200', '361100'),
        ('350213', 4, '翔安区', '350200', '361101'),
        ('350214', 4, '其它区', '350200', ''),
        ('350300', 3, '莆田市', '350000', '351100'),
        ('350302', 4, '城厢区', '350300', '351100'),
        ('350303', 4, '涵江区', '350300', '351111'),
        ('350304', 4, '荔城区', '350300', '351100'),
        ('350305', 4, '秀屿区', '350300', '351152'),
        ('350322', 4, '仙游县', '350300', '351200'),
        ('350323', 4, '其它区', '350300', ''),
        ('350400', 3, '三明市', '350000', '365000'),
        ('350402', 4, '梅列区', '350400', '365000'),
        ('350403', 4, '三元区', '350400', '365001'),
        ('350421', 4, '明溪县', '350400', '365200'),
        ('350423', 4, '清流县', '350400', '365300'),
        ('350424', 4, '宁化县', '350400', '365400'),
        ('350425', 4, '大田县', '350400', '366100'),
        ('350426', 4, '尤溪县', '350400', '365100'),
        ('350427', 4, '沙县', '350400', '365500'),
        ('350428', 4, '将乐县', '350400', '353300'),
        ('350429', 4, '泰宁县', '350400', '354400'),
        ('350430', 4, '建宁县', '350400', '354500'),
        ('350481', 4, '永安市', '350400', '366000'),
        ('350482', 4, '其它区', '350400', ''),
        ('350500', 3, '泉州市', '350000', '362000'),
        ('350502', 4, '鲤城区', '350500', '362000'),
        ('350503', 4, '丰泽区', '350500', '362000'),
        ('350504', 4, '洛江区', '350500', '362011'),
        ('350505', 4, '泉港区', '350500', '362801'),
        ('350521', 4, '惠安县', '350500', '362100'),
        ('350524', 4, '安溪县', '350500', '362400'),
        ('350525', 4, '永春县', '350500', '362600'),
        ('350526', 4, '德化县', '350500', '362500'),
        ('350527', 4, '金门县', '350500', '362000'),
        ('350581', 4, '石狮市', '350500', '362700'),
        ('350582', 4, '晋江市', '350500', '362200'),
        ('350583', 4, '南安市', '350500', '362300'),
        ('350584', 4, '其它区', '350500', ''),
        ('350600', 3, '漳州市', '350000', '363000'),
        ('350602', 4, '芗城区', '350600', '363000'),
        ('350603', 4, '龙文区', '350600', '363005'),
        ('350622', 4, '云霄县', '350600', '363300'),
        ('350623', 4, '漳浦县', '350600', '363200'),
        ('350624', 4, '诏安县', '350600', '363500'),
        ('350625', 4, '长泰县', '350600', '363900'),
        ('350626', 4, '东山县', '350600', '363400'),
        ('350627', 4, '南靖县', '350600', '363600'),
        ('350628', 4, '平和县', '350600', '363700'),
        ('350629', 4, '华安县', '350600', '363800'),
        ('350681', 4, '龙海市', '350600', '363100'),
        ('350682', 4, '其它区', '350600', ''),
        ('350700', 3, '南平市', '350000', '353000'),
        ('350702', 4, '延平区', '350700', '353000'),
        ('350721', 4, '顺昌县', '350700', '353200'),
        ('350722', 4, '浦城县', '350700', '353400'),
        ('350723', 4, '光泽县', '350700', '354100'),
        ('350724', 4, '松溪县', '350700', '353500'),
        ('350725', 4, '政和县', '350700', '353600'),
        ('350781', 4, '邵武市', '350700', '354000'),
        ('350782', 4, '武夷山市', '350700', '354300'),
        ('350783', 4, '建瓯市', '350700', '353100'),
        ('350784', 4, '建阳市', '350700', '354200'),
        ('350785', 4, '其它区', '350700', ''),
        ('350800', 3, '龙岩市', '350000', '364000'),
        ('350802', 4, '新罗区', '350800', '364000'),
        ('350821', 4, '长汀县', '350800', '366300'),
        ('350822', 4, '永定县', '350800', '364100'),
        ('350823', 4, '上杭县', '350800', '364200'),
        ('350824', 4, '武平县', '350800', '364300'),
        ('350825', 4, '连城县', '350800', '366200'),
        ('350881', 4, '漳平市', '350800', '364400'),
        ('350882', 4, '其它区', '350800', ''),
        ('350900', 3, '宁德市', '350000', '352100'),
        ('350902', 4, '蕉城区', '350900', '352100'),
        ('350921', 4, '霞浦县', '350900', '355100'),
        ('350922', 4, '古田县', '350900', '352200'),
        ('350923', 4, '屏南县', '350900', '352300'),
        ('350924', 4, '寿宁县', '350900', '355500'),
        ('350925', 4, '周宁县', '350900', '355400'),
        ('350926', 4, '柘荣县', '350900', '355300'),
        ('350981', 4, '福安市', '350900', '355000'),
        ('350982', 4, '福鼎市', '350900', '355200'),
        ('350983', 4, '其它区', '350900', ''),
        ('360000', 2, '江西省', '1', ''),
        ('360100', 3, '南昌市', '360000', '330000'),
        ('360102', 4, '东湖区', '360100', '330006'),
        ('360103', 4, '西湖区', '360100', '330009'),
        ('360104', 4, '青云谱区', '360100', '330001'),
        ('360105', 4, '湾里区', '360100', '330004'),
        ('360111', 4, '青山湖区', '360100', '330006'),
        ('360121', 4, '南昌县', '360100', '330200'),
        ('360122', 4, '新建县', '360100', '330100'),
        ('360123', 4, '安义县', '360100', '330500'),
        ('360124', 4, '进贤县', '360100', '331700'),
        ('360125', 4, '红谷滩新区', '360100', ''),
        ('360126', 4, '经济技术开发区', '360100', ''),
        ('360127', 4, '昌北区', '360100', ''),
        ('360128', 4, '其它区', '360100', ''),
        ('360200', 3, '景德镇市', '360000', '333000'),
        ('360202', 4, '昌江区', '360200', '333000'),
        ('360203', 4, '珠山区', '360200', '333000'),
        ('360222', 4, '浮梁县', '360200', '333400'),
        ('360281', 4, '乐平市', '360200', '333300'),
        ('360282', 4, '其它区', '360200', ''),
        ('360300', 3, '萍乡市', '360000', '337000'),
        ('360302', 4, '安源区', '360300', '337000'),
        ('360313', 4, '湘东区', '360300', '337032'),
        ('360321', 4, '莲花县', '360300', '337100'),
        ('360322', 4, '上栗县', '360300', '337009'),
        ('360323', 4, '芦溪县', '360300', '337200'),
        ('360324', 4, '其它区', '360300', ''),
        ('360400', 3, '九江市', '360000', '332000'),
        ('360402', 4, '庐山区', '360400', '332005'),
        ('360403', 4, '浔阳区', '360400', '332000'),
        ('360421', 4, '九江县', '360400', '332100'),
        ('360423', 4, '武宁县', '360400', '332300'),
        ('360424', 4, '修水县', '360400', '332400'),
        ('360425', 4, '永修县', '360400', '330300'),
        ('360426', 4, '德安县', '360400', '330400'),
        ('360427', 4, '星子县', '360400', '332800'),
        ('360428', 4, '都昌县', '360400', '332600'),
        ('360429', 4, '湖口县', '360400', '332500'),
        ('360430', 4, '彭泽县', '360400', '332700'),
        ('360481', 4, '瑞昌市', '360400', '332200'),
        ('360482', 4, '其它区', '360400', ''),
        ('360500', 3, '新余市', '360000', '338000'),
        ('360502', 4, '渝水区', '360500', '338025'),
        ('360521', 4, '分宜县', '360500', '336600'),
        ('360522', 4, '其它区', '360500', ''),
        ('360600', 3, '鹰潭市', '360000', '335000'),
        ('360602', 4, '月湖区', '360600', '335000'),
        ('360622', 4, '余江县', '360600', '335200'),
        ('360681', 4, '贵溪市', '360600', '335400'),
        ('360682', 4, '其它区', '360600', ''),
        ('360700', 3, '赣州市', '360000', '341000'),
        ('360702', 4, '章贡区', '360700', ''),
        ('360721', 4, '赣县', '360700', '341100'),
        ('360722', 4, '信丰县', '360700', '341600'),
        ('360723', 4, '大余县', '360700', '341500'),
        ('360724', 4, '上犹县', '360700', '341200'),
        ('360725', 4, '崇义县', '360700', '341300'),
        ('360726', 4, '安远县', '360700', '342100'),
        ('360727', 4, '龙南县', '360700', '341700'),
        ('360728', 4, '定南县', '360700', '341900'),
        ('360729', 4, '全南县', '360700', '341800'),
        ('360730', 4, '宁都县', '360700', '342800'),
        ('360731', 4, '于都县', '360700', '342300'),
        ('360732', 4, '兴国县', '360700', '342400'),
        ('360733', 4, '会昌县', '360700', '342600'),
        ('360734', 4, '寻乌县', '360700', '342200'),
        ('360735', 4, '石城县', '360700', '342700'),
        ('360751', 4, '黄金区', '360700', ''),
        ('360781', 4, '瑞金市', '360700', '342500'),
        ('360782', 4, '南康市', '360700', '341400'),
        ('360783', 4, '其它区', '360700', ''),
        ('360800', 3, '吉安市', '360000', '343000'),
        ('360802', 4, '吉州区', '360800', '343000'),
        ('360803', 4, '青原区', '360800', '343009'),
        ('360821', 4, '吉安县', '360800', '343100'),
        ('360822', 4, '吉水县', '360800', '331600'),
        ('360823', 4, '峡江县', '360800', '331400'),
        ('360824', 4, '新干县', '360800', '331300'),
        ('360825', 4, '永丰县', '360800', '331500'),
        ('360826', 4, '泰和县', '360800', '343700'),
        ('360827', 4, '遂川县', '360800', '343900'),
        ('360828', 4, '万安县', '360800', '343800'),
        ('360829', 4, '安福县', '360800', '343200'),
        ('360830', 4, '永新县', '360800', '343400'),
        ('360881', 4, '井冈山市', '360800', '343600'),
        ('360882', 4, '其它区', '360800', ''),
        ('360900', 3, '宜春市', '360000', '336000'),
        ('360902', 4, '袁州区', '360900', '336000'),
        ('360921', 4, '奉新县', '360900', '330700'),
        ('360922', 4, '万载县', '360900', '336100'),
        ('360923', 4, '上高县', '360900', '336400'),
        ('360924', 4, '宜丰县', '360900', '336300'),
        ('360925', 4, '靖安县', '360900', '330600'),
        ('360926', 4, '铜鼓县', '360900', '336200'),
        ('360981', 4, '丰城市', '360900', '331100'),
        ('360982', 4, '樟树市', '360900', '331200'),
        ('360983', 4, '高安市', '360900', '330800'),
        ('360984', 4, '其它区', '360900', ''),
        ('361000', 3, '抚州市', '360000', '344000'),
        ('361002', 4, '临川区', '361000', '344100'),
        ('361021', 4, '南城县', '361000', '344700'),
        ('361022', 4, '黎川县', '361000', '344600'),
        ('361023', 4, '南丰县', '361000', '344500'),
        ('361024', 4, '崇仁县', '361000', '344200'),
        ('361025', 4, '乐安县', '361000', '344300'),
        ('361026', 4, '宜黄县', '361000', '344400'),
        ('361027', 4, '金溪县', '361000', '344800'),
        ('361028', 4, '资溪县', '361000', '335300'),
        ('361029', 4, '东乡县', '361000', '331800'),
        ('361030', 4, '广昌县', '361000', '344900'),
        ('361031', 4, '其它区', '361000', ''),
        ('361100', 3, '上饶市', '360000', '334000'),
        ('361102', 4, '信州区', '361100', '334000'),
        ('361121', 4, '上饶县', '361100', '334100'),
        ('361122', 4, '广丰县', '361100', '334600'),
        ('361123', 4, '玉山县', '361100', '334700'),
        ('361124', 4, '铅山县', '361100', '334500'),
        ('361125', 4, '横峰县', '361100', '334300'),
        ('361126', 4, '弋阳县', '361100', '334400'),
        ('361127', 4, '余干县', '361100', '335100'),
        ('361128', 4, '鄱阳县', '361100', '333100'),
        ('361129', 4, '万年县', '361100', '335500'),
        ('361130', 4, '婺源县', '361100', '333200'),
        ('361181', 4, '德兴市', '361100', '334200'),
        ('361182', 4, '其它区', '361100', ''),
        ('370000', 2, '山东省', '1', ''),
        ('370100', 3, '济南市', '370000', '250000'),
        ('370102', 4, '历下区', '370100', '250013'),
        ('370103', 4, '市中区', '370100', '250002'),
        ('370104', 4, '槐荫区', '370100', '250021'),
        ('370105', 4, '天桥区', '370100', '250031'),
        ('370112', 4, '历城区', '370100', '250100'),
        ('370113', 4, '长清区', '370100', '250300'),
        ('370124', 4, '平阴县', '370100', '250400'),
        ('370125', 4, '济阳县', '370100', '251400'),
        ('370126', 4, '商河县', '370100', '251600'),
        ('370181', 4, '章丘市', '370100', '250200'),
        ('370182', 4, '其它区', '370100', ''),
        ('370200', 3, '青岛市', '370000', '266000'),
        ('370202', 4, '市南区', '370200', '266001'),
        ('370203', 4, '市北区', '370200', '266011'),
        ('370205', 4, '四方区', '370200', '266031'),
        ('370211', 4, '黄岛区', '370200', '266500'),
        ('370212', 4, '崂山区', '370200', '266100'),
        ('370213', 4, '李沧区', '370200', '266100'),
        ('370214', 4, '城阳区', '370200', '266041'),
        ('370251', 4, '开发区', '370200', ''),
        ('370281', 4, '胶州市', '370200', '266300'),
        ('370282', 4, '即墨市', '370200', '266200'),
        ('370283', 4, '平度市', '370200', '266700'),
        ('370284', 4, '胶南市', '370200', '266400'),
        ('370285', 4, '莱西市', '370200', '266600'),
        ('370286', 4, '其它区', '370200', ''),
        ('370300', 3, '淄博市', '370000', '255000'),
        ('370302', 4, '淄川区', '370300', '255100'),
        ('370303', 4, '张店区', '370300', '255022'),
        ('370304', 4, '博山区', '370300', '255200'),
        ('370305', 4, '临淄区', '370300', '255400'),
        ('370306', 4, '周村区', '370300', '255300'),
        ('370321', 4, '桓台县', '370300', '256400'),
        ('370322', 4, '高青县', '370300', '256300'),
        ('370323', 4, '沂源县', '370300', '256100'),
        ('370324', 4, '其它区', '370300', ''),
        ('370400', 3, '枣庄市', '370000', '277100'),
        ('370402', 4, '市中区', '370400', '277101'),
        ('370403', 4, '薛城区', '370400', '277000'),
        ('370404', 4, '峄城区', '370400', '277300'),
        ('370405', 4, '台儿庄区', '370400', '277400'),
        ('370406', 4, '山亭区', '370400', '277200'),
        ('370481', 4, '滕州市', '370400', '277500'),
        ('370482', 4, '其它区', '370400', ''),
        ('370500', 3, '东营市', '370000', '257000'),
        ('370502', 4, '东营区', '370500', '\r\n257029'),
        ('370503', 4, '河口区', '370500', '257200'),
        ('370521', 4, '垦利县', '370500', '257500'),
        ('370522', 4, '利津县', '370500', '257400'),
        ('370523', 4, '广饶县', '370500', '257300'),
        ('370589', 4, '西城区', '370500', ''),
        ('370590', 4, '东城区', '370500', ''),
        ('370591', 4, '其它区', '370500', ''),
        ('370600', 3, '烟台市', '370000', '264000'),
        ('370602', 4, '芝罘区', '370600', '264001'),
        ('370611', 4, '福山区', '370600', '265500'),
        ('370612', 4, '牟平区', '370600', '264100'),
        ('370613', 4, '莱山区', '370600', '264600'),
        ('370634', 4, '长岛县', '370600', '265800'),
        ('370681', 4, '龙口市', '370600', '265700'),
        ('370682', 4, '莱阳市', '370600', '265200'),
        ('370683', 4, '莱州市', '370600', '261400'),
        ('370684', 4, '蓬莱市', '370600', '265600'),
        ('370685', 4, '招远市', '370600', '265400'),
        ('370686', 4, '栖霞市', '370600', '265300'),
        ('370687', 4, '海阳市', '370600', '265100'),
        ('370688', 4, '其它区', '370600', ''),
        ('370700', 3, '潍坊市', '370000', '261000'),
        ('370702', 4, '潍城区', '370700', '261021'),
        ('370703', 4, '寒亭区', '370700', '261100'),
        ('370704', 4, '坊子区', '370700', '261200'),
        ('370705', 4, '奎文区', '370700', '261041'),
        ('370724', 4, '临朐县', '370700', '262600'),
        ('370725', 4, '昌乐县', '370700', '262400'),
        ('370751', 4, '开发区', '370700', ''),
        ('370781', 4, '青州市', '370700', '262500'),
        ('370782', 4, '诸城市', '370700', '262200'),
        ('370783', 4, '寿光市', '370700', '262700'),
        ('370784', 4, '安丘市', '370700', '262100'),
        ('370785', 4, '高密市', '370700', '261500'),
        ('370786', 4, '昌邑市', '370700', '261300'),
        ('370787', 4, '其它区', '370700', ''),
        ('370800', 3, '济宁市', '370000', '272100'),
        ('370802', 4, '市中区', '370800', '272133'),
        ('370811', 4, '任城区', '370800', '272113'),
        ('370826', 4, '微山县', '370800', '277600'),
        ('370827', 4, '鱼台县', '370800', '272300'),
        ('370828', 4, '金乡县', '370800', '272200'),
        ('370829', 4, '嘉祥县', '370800', '272400'),
        ('370830', 4, '汶上县', '370800', '272501'),
        ('370831', 4, '泗水县', '370800', '273200'),
        ('370832', 4, '梁山县', '370800', '272600'),
        ('370881', 4, '曲阜市', '370800', '273100'),
        ('370882', 4, '兖州市', '370800', '272000'),
        ('370883', 4, '邹城市', '370800', '273500'),
        ('370884', 4, '其它区', '370800', ''),
        ('370900', 3, '泰安市', '370000', '271000'),
        ('370902', 4, '泰山区', '370900', '271000'),
        ('370903', 4, '岱岳区', '370900', '271000'),
        ('370921', 4, '宁阳县', '370900', '271400'),
        ('370923', 4, '东平县', '370900', '271500'),
        ('370982', 4, '新泰市', '370900', '271200'),
        ('370983', 4, '肥城市', '370900', '271600'),
        ('370984', 4, '其它区', '370900', ''),
        ('371000', 3, '威海市', '370000', '264200'),
        ('371002', 4, '环翠区', '371000', '264200'),
        ('371081', 4, '文登市', '371000', '264400'),
        ('371082', 4, '荣成市', '371000', '264300'),
        ('371083', 4, '乳山市', '371000', '264500'),
        ('371084', 4, '其它区', '371000', ''),
        ('371100', 3, '日照市', '370000', '276800'),
        ('371102', 4, '东港区', '371100', '276800'),
        ('371103', 4, '岚山区', '371100', '276808'),
        ('371121', 4, '五莲县', '371100', '262300'),
        ('371122', 4, '莒县', '371100', '276500'),
        ('371123', 4, '其它区', '371100', ''),
        ('371200', 3, '莱芜市', '370000', '271100'),
        ('371202', 4, '莱城区', '371200', '271100'),
        ('371203', 4, '钢城区', '371200', '271100'),
        ('371204', 4, '其它区', '371200', ''),
        ('371300', 3, '临沂市', '370000', '276000'),
        ('371302', 4, '兰山区', '371300', '276002'),
        ('371311', 4, '罗庄区', '371300', '276022'),
        ('371312', 4, '河东区', '371300', '276034'),
        ('371321', 4, '沂南县', '371300', '276300'),
        ('371322', 4, '郯城县', '371300', '276100'),
        ('371323', 4, '沂水县', '371300', '276400'),
        ('371324', 4, '苍山县', '371300', '277700'),
        ('371325', 4, '费县', '371300', '273400'),
        ('371326', 4, '平邑县', '371300', '273300'),
        ('371327', 4, '莒南县', '371300', '276600'),
        ('371328', 4, '蒙阴县', '371300', '276200'),
        ('371329', 4, '临沭县', '371300', '276700'),
        ('371330', 4, '其它区', '371300', ''),
        ('371400', 3, '德州市', '370000', '253000'),
        ('371402', 4, '德城区', '371400', '253011'),
        ('371421', 4, '陵县', '371400', '253500'),
        ('371422', 4, '宁津县', '371400', '253400'),
        ('371423', 4, '庆云县', '371400', '253700'),
        ('371424', 4, '临邑县', '371400', '251500'),
        ('371425', 4, '齐河县', '371400', '251100'),
        ('371426', 4, '平原县', '371400', '253121'),
        ('371427', 4, '夏津县', '371400', '253200'),
        ('371428', 4, '武城县', '371400', '253300'),
        ('371451', 4, '开发区', '371400', ''),
        ('371481', 4, '乐陵市', '371400', '253600'),
        ('371482', 4, '禹城市', '371400', '251200'),
        ('371483', 4, '其它区', '371400', ''),
        ('371500', 3, '聊城市', '370000', '252000'),
        ('371502', 4, '东昌府区', '371500', '252000'),
        ('371521', 4, '阳谷县', '371500', '252300'),
        ('371522', 4, '莘县', '371500', '252400'),
        ('371523', 4, '茌平县', '371500', '252100'),
        ('371524', 4, '东阿县', '371500', '252200'),
        ('371525', 4, '冠县', '371500', '252500'),
        ('371526', 4, '高唐县', '371500', '252800'),
        ('371581', 4, '临清市', '371500', '252600'),
        ('371582', 4, '其它区', '371500', ''),
        ('371600', 3, '滨州市', '370000', '256600'),
        ('371602', 4, '滨城区', '371600', '256600'),
        ('371621', 4, '惠民县', '371600', '257100'),
        ('371622', 4, '阳信县', '371600', '251800'),
        ('371623', 4, '无棣县', '371600', '251900'),
        ('371624', 4, '沾化县', '371600', '256800'),
        ('371625', 4, '博兴县', '371600', '256500'),
        ('371626', 4, '邹平县', '371600', '256200'),
        ('371627', 4, '其它区', '371600', ''),
        ('371700', 3, '菏泽市', '370000', '274000'),
        ('371702', 4, '牡丹区', '371700', '274009'),
        ('371721', 4, '曹县', '371700', '274400'),
        ('371722', 4, '单县', '371700', '274300'),
        ('371723', 4, '成武县', '371700', '274200'),
        ('371724', 4, '巨野县', '371700', '274900'),
        ('371725', 4, '郓城县', '371700', '274700'),
        ('371726', 4, '鄄城县', '371700', '274600'),
        ('371727', 4, '定陶县', '371700', '274100'),
        ('371728', 4, '东明县', '371700', '274500'),
        ('371729', 4, '其它区', '371700', ''),
        ('410000', 2, '河南省', '1', ''),
        ('410100', 3, '郑州市', '410000', '450000'),
        ('410102', 4, '中原区', '410100', '450007'),
        ('410103', 4, '二七区', '410100', '450000'),
        ('410104', 4, '管城回族区', '410100', '450000'),
        ('410105', 4, '金水区', '410100', '450003'),
        ('410106', 4, '上街区', '410100', '450041'),
        ('410108', 4, '惠济区', '410100', '450053'),
        ('410122', 4, '中牟县', '410100', '451450'),
        ('410181', 4, '巩义市', '410100', '451200'),
        ('410182', 4, '荥阳市', '410100', '450100'),
        ('410183', 4, '新密市', '410100', '452300'),
        ('410184', 4, '新郑市', '410100', '451150'),
        ('410185', 4, '登封市', '410100', '452470'),
        ('410186', 4, '郑东新区', '410100', ''),
        ('410187', 4, '高新区', '410100', ''),
        ('410188', 4, '其它区', '410100', ''),
        ('410200', 3, '开封市', '410000', '475000'),
        ('410202', 4, '龙亭区', '410200', '475100'),
        ('410203', 4, '顺河回族区', '410200', '475000'),
        ('410204', 4, '鼓楼区', '410200', '475000'),
        ('410205', 4, '禹王台区', '410200', '475003'),
        ('410211', 4, '金明区', '410200', '475002'),
        ('410221', 4, '杞县', '410200', '475200'),
        ('410222', 4, '通许县', '410200', '475400'),
        ('410223', 4, '尉氏县', '410200', '475500'),
        ('410224', 4, '开封县', '410200', '475100'),
        ('410225', 4, '兰考县', '410200', '475300'),
        ('410226', 4, '其它区', '410200', ''),
        ('410300', 3, '洛阳市', '410000', '471000'),
        ('410302', 4, '老城区', '410300', '471002'),
        ('410303', 4, '西工区', '410300', '471000'),
        ('410304', 4, '廛河回族区', '410300', '471002'),
        ('410305', 4, '涧西区', '410300', '471003'),
        ('410306', 4, '吉利区', '410300', '471012'),
        ('410307', 4, '洛龙区', '410300', '471000'),
        ('410322', 4, '孟津县', '410300', '471100'),
        ('410323', 4, '新安县', '410300', '471800'),
        ('410324', 4, '栾川县', '410300', '471500'),
        ('410325', 4, '嵩县', '410300', '471400'),
        ('410326', 4, '汝阳县', '410300', '471200'),
        ('410327', 4, '宜阳县', '410300', '471600'),
        ('410328', 4, '洛宁县', '410300', '471700'),
        ('410329', 4, '伊川县', '410300', '471300'),
        ('410381', 4, '偃师市', '410300', '471900'),
        ('410400', 3, '平顶山市', '410000', '467000'),
        ('410402', 4, '新华区', '410400', '467002'),
        ('410403', 4, '卫东区', '410400', '467021'),
        ('410404', 4, '石龙区', '410400', '467045'),
        ('410411', 4, '湛河区', '410400', '467000'),
        ('410421', 4, '宝丰县', '410400', '467400'),
        ('410422', 4, '叶县', '410400', '467200'),
        ('410423', 4, '鲁山县', '410400', '467300'),
        ('410425', 4, '郏县', '410400', '467100'),
        ('410481', 4, '舞钢市', '410400', '462500'),
        ('410482', 4, '汝州市', '410400', '467500'),
        ('410483', 4, '其它区', '410400', ''),
        ('410500', 3, '安阳市', '410000', '455000'),
        ('410502', 4, '文峰区', '410500', '455000'),
        ('410503', 4, '北关区', '410500', '455001'),
        ('410505', 4, '殷都区', '410500', '455004'),
        ('410506', 4, '龙安区', '410500', '455001'),
        ('410522', 4, '安阳县', '410500', '455100'),
        ('410523', 4, '汤阴县', '410500', '456150'),
        ('410526', 4, '滑县', '410500', '456400'),
        ('410527', 4, '内黄县', '410500', '456300'),
        ('410581', 4, '林州市', '410500', '456500'),
        ('410582', 4, '其它区', '410500', ''),
        ('410600', 3, '鹤壁市', '410000', '458000'),
        ('410602', 4, '鹤山区', '410600', '458010'),
        ('410603', 4, '山城区', '410600', '458000'),
        ('410611', 4, '淇滨区', '410600', '458030'),
        ('410621', 4, '浚县', '410600', '456250'),
        ('410622', 4, '淇县', '410600', '456750'),
        ('410623', 4, '其它区', '410600', ''),
        ('410700', 3, '新乡市', '410000', '453000'),
        ('410702', 4, '红旗区', '410700', '453000'),
        ('410703', 4, '卫滨区', '410700', '453000'),
        ('410704', 4, '凤泉区', '410700', '453011'),
        ('410711', 4, '牧野区', '410700', '453002'),
        ('410721', 4, '新乡县', '410700', '453700'),
        ('410724', 4, '获嘉县', '410700', '453800'),
        ('410725', 4, '原阳县', '410700', '453500'),
        ('410726', 4, '延津县', '410700', '453200'),
        ('410727', 4, '封丘县', '410700', '453300'),
        ('410728', 4, '长垣县', '410700', '453400'),
        ('410781', 4, '卫辉市', '410700', '453100'),
        ('410782', 4, '辉县市', '410700', '453600'),
        ('410783', 4, '其它区', '410700', ''),
        ('410800', 3, '焦作市', '410000', '454000'),
        ('410802', 4, '解放区', '410800', '454000'),
        ('410803', 4, '中站区', '410800', '454191'),
        ('410804', 4, '马村区', '410800', '454171'),
        ('410811', 4, '山阳区', '410800', '454002'),
        ('410821', 4, '修武县', '410800', '454350'),
        ('410822', 4, '博爱县', '410800', '454450'),
        ('410823', 4, '武陟县', '410800', '454950'),
        ('410825', 4, '温县', '410800', '454850'),
        ('410881', 4, '济源市', '410000', '454650'),
        ('410882', 4, '沁阳市', '410800', '454550'),
        ('410883', 4, '孟州市', '410800', '454750'),
        ('410884', 4, '其它区', '410800', ''),
        ('410900', 3, '濮阳市', '410000', '457000'),
        ('410902', 4, '华龙区', '410900', '457001'),
        ('410922', 4, '清丰县', '410900', '457300'),
        ('410923', 4, '南乐县', '410900', '457400'),
        ('410926', 4, '范县', '410900', '457500'),
        ('410927', 4, '台前县', '410900', '457600'),
        ('410928', 4, '濮阳县', '410900', '457100'),
        ('410929', 4, '其它区', '410900', ''),
        ('411000', 3, '许昌市', '410000', '461000'),
        ('411002', 4, '魏都区', '411000', '461000'),
        ('411023', 4, '许昌县', '411000', '461100'),
        ('411024', 4, '鄢陵县', '411000', '461200'),
        ('411025', 4, '襄城县', '411000', '461700'),
        ('411081', 4, '禹州市', '411000', '461670'),
        ('411082', 4, '长葛市', '411000', '461500'),
        ('411083', 4, '其它区', '411000', ''),
        ('411100', 3, '漯河市', '410000', '462000'),
        ('411102', 4, '源汇区', '411100', '462000'),
        ('411103', 4, '郾城区', '411100', '462300'),
        ('411104', 4, '召陵区', '411100', '462300'),
        ('411121', 4, '舞阳县', '411100', '462400'),
        ('411122', 4, '临颍县', '411100', '462600'),
        ('411123', 4, '其它区', '411100', ''),
        ('411200', 3, '三门峡市', '410000', '472000'),
        ('411202', 4, '湖滨区', '411200', '472000'),
        ('411221', 4, '渑池县', '411200', '472400'),
        ('411222', 4, '陕县', '411200', '472100'),
        ('411224', 4, '卢氏县', '411200', '472200'),
        ('411281', 4, '义马市', '411200', '472300'),
        ('411282', 4, '灵宝市', '411200', '472500'),
        ('411283', 4, '其它区', '411200', ''),
        ('411300', 3, '南阳市', '410000', '473000'),
        ('411302', 4, '宛城区', '411300', '473001'),
        ('411303', 4, '卧龙区', '411300', '473003'),
        ('411321', 4, '南召县', '411300', '474650'),
        ('411322', 4, '方城县', '411300', '473200'),
        ('411323', 4, '西峡县', '411300', '474550'),
        ('411324', 4, '镇平县', '411300', '474250'),
        ('411325', 4, '内乡县', '411300', '474350'),
        ('411326', 4, '淅川县', '411300', '474450'),
        ('411327', 4, '社旗县', '411300', '473300'),
        ('411328', 4, '唐河县', '411300', '473400'),
        ('411329', 4, '新野县', '411300', '473500'),
        ('411330', 4, '桐柏县', '411300', '474750'),
        ('411381', 4, '邓州市', '411300', '474150'),
        ('411382', 4, '其它区', '411300', ''),
        ('411400', 3, '商丘市', '410000', '476000'),
        ('411402', 4, '梁园区', '411400', '476000'),
        ('411403', 4, '睢阳区', '411400', '476100'),
        ('411421', 4, '民权县', '411400', '476800'),
        ('411422', 4, '睢县', '411400', '476900'),
        ('411423', 4, '宁陵县', '411400', '476700'),
        ('411424', 4, '柘城县', '411400', '476200'),
        ('411425', 4, '虞城县', '411400', '476300'),
        ('411426', 4, '夏邑县', '411400', '476400'),
        ('411481', 4, '永城市', '411400', '476600'),
        ('411482', 4, '其它区', '411400', ''),
        ('411500', 3, '信阳市', '410000', '464000'),
        ('411502', 4, '浉河区', '411500', '464000'),
        ('411503', 4, '平桥区', '411500', '464100'),
        ('411521', 4, '罗山县', '411500', '464200'),
        ('411522', 4, '光山县', '411500', '465450'),
        ('411523', 4, '新县', '411500', '465550'),
        ('411524', 4, '商城县', '411500', '465350'),
        ('411525', 4, '固始县', '411500', '465200'),
        ('411526', 4, '潢川县', '411500', '465150'),
        ('411527', 4, '淮滨县', '411500', '464400'),
        ('411528', 4, '息县', '411500', '464300'),
        ('411529', 4, '其它区', '411500', ''),
        ('411600', 3, '周口市', '410000', '466000'),
        ('411602', 4, '川汇区', '411600', '466000'),
        ('411621', 4, '扶沟县', '411600', '461300'),
        ('411622', 4, '西华县', '411600', '466600'),
        ('411623', 4, '商水县', '411600', '466100'),
        ('411624', 4, '沈丘县', '411600', '466300'),
        ('411625', 4, '郸城县', '411600', '477150'),
        ('411626', 4, '淮阳县', '411600', '466700'),
        ('411627', 4, '太康县', '411600', '475400'),
        ('411628', 4, '鹿邑县', '411600', '477200'),
        ('411681', 4, '项城市', '411600', '466200'),
        ('411682', 4, '其它区', '411600', ''),
        ('411700', 3, '驻马店市', '410000', '463000'),
        ('411702', 4, '驿城区', '411700', '463000'),
        ('411721', 4, '西平县', '411700', '463900'),
        ('411722', 4, '上蔡县', '411700', '463800'),
        ('411723', 4, '平舆县', '411700', '463400'),
        ('411724', 4, '正阳县', '411700', '463600'),
        ('411725', 4, '确山县', '411700', '463200'),
        ('411726', 4, '泌阳县', '411700', '463700'),
        ('411727', 4, '汝南县', '411700', '463300'),
        ('411728', 4, '遂平县', '411700', '463100'),
        ('411729', 4, '新蔡县', '411700', '463500'),
        ('411730', 4, '其它区', '411700', ''),
        ('420000', 2, '湖北省', '1', ''),
        ('420100', 3, '武汉市', '420000', '430000'),
        ('420102', 4, '江岸区', '420100', '430014'),
        ('420103', 4, '江汉区', '420100', '430015'),
        ('420104', 4, '硚口区', '420100', '430033'),
        ('420105', 4, '汉阳区', '420100', '430050'),
        ('420106', 4, '武昌区', '420100', '430061'),
        ('420107', 4, '青山区', '420100', '430080'),
        ('420111', 4, '洪山区', '420100', '430070'),
        ('420112', 4, '东西湖区', '420100', '430040'),
        ('420113', 4, '汉南区', '420100', '430090'),
        ('420114', 4, '蔡甸区', '420100', '430100'),
        ('420115', 4, '江夏区', '420100', '430200'),
        ('420116', 4, '黄陂区', '420100', '430300'),
        ('420117', 4, '新洲区', '420100', '431400'),
        ('420118', 4, '其它区', '420100', ''),
        ('420200', 3, '黄石市', '420000', '435000'),
        ('420202', 4, '黄石港区', '420200', '435002'),
        ('420203', 4, '西塞山区', '420200', '435001'),
        ('420204', 4, '下陆区', '420200', '435004'),
        ('420205', 4, '铁山区', '420200', '435006'),
        ('420222', 4, '阳新县', '420200', '435200'),
        ('420281', 4, '大冶市', '420200', '435100'),
        ('420282', 4, '其它区', '420200', ''),
        ('420300', 3, '十堰市', '420000', '442000'),
        ('420302', 4, '茅箭区', '420300', '442012'),
        ('420303', 4, '张湾区', '420300', '442001'),
        ('420321', 4, '郧县', '420300', '442500'),
        ('420322', 4, '郧西县', '420300', '442600'),
        ('420323', 4, '竹山县', '420300', '442200'),
        ('420324', 4, '竹溪县', '420300', '442300'),
        ('420325', 4, '房县', '420300', '442100'),
        ('420381', 4, '丹江口市', '420300', '441900'),
        ('420382', 4, '城区', '420300', ''),
        ('420383', 4, '其它区', '420300', ''),
        ('420500', 3, '宜昌市', '420000', '443000'),
        ('420502', 4, '西陵区', '420500', '443000'),
        ('420503', 4, '伍家岗区', '420500', '443001'),
        ('420504', 4, '点军区', '420500', '443006'),
        ('420505', 4, '猇亭区', '420500', '443007'),
        ('420506', 4, '夷陵区', '420500', '443100'),
        ('420525', 4, '远安县', '420500', '444200'),
        ('420526', 4, '兴山县', '420500', '443700'),
        ('420527', 4, '秭归县', '420500', '443600'),
        ('420528', 4, '长阳土家族自治县', '420500', '443500'),
        ('420529', 4, '五峰土家族自治县', '420500', '443400'),
        ('420551', 4, '葛洲坝区', '420500', ''),
        ('420552', 4, '开发区', '420500', ''),
        ('420581', 4, '宜都市', '420500', '443300'),
        ('420582', 4, '当阳市', '420500', '444100'),
        ('420583', 4, '枝江市', '420500', '443200'),
        ('420584', 4, '其它区', '420500', ''),
        ('420600', 3, '襄阳市', '420000', '441000'),
        ('420602', 4, '襄城区', '420600', '441021'),
        ('420606', 4, '樊城区', '420600', '441001'),
        ('420607', 4, '襄州区', '420600', '441100'),
        ('420624', 4, '南漳县', '420600', '441500'),
        ('420625', 4, '谷城县', '420600', '441700'),
        ('420626', 4, '保康县', '420600', '441600'),
        ('420682', 4, '老河口市', '420600', '441800'),
        ('420683', 4, '枣阳市', '420600', '441200'),
        ('420684', 4, '宜城市', '420600', '441400'),
        ('420685', 4, '其它区', '420600', ''),
        ('420700', 3, '鄂州市', '420000', '436000'),
        ('420702', 4, '梁子湖区', '420700', '436064'),
        ('420703', 4, '华容区', '420700', '436030'),
        ('420704', 4, '鄂城区', '420700', '436000'),
        ('420705', 4, '其它区', '420700', ''),
        ('420800', 3, '荆门市', '420000', '448000'),
        ('420802', 4, '东宝区', '420800', '448004'),
        ('420804', 4, '掇刀区', '420800', '448124'),
        ('420821', 4, '京山县', '420800', '431800'),
        ('420822', 4, '沙洋县', '420800', '448200'),
        ('420881', 4, '钟祥市', '420800', '431900'),
        ('420882', 4, '其它区', '420800', ''),
        ('420900', 3, '孝感市', '420000', '432000'),
        ('420902', 4, '孝南区', '420900', '432100'),
        ('420921', 4, '孝昌县', '420900', '432900'),
        ('420922', 4, '大悟县', '420900', '432800'),
        ('420923', 4, '云梦县', '420900', '432500'),
        ('420981', 4, '应城市', '420900', '432400'),
        ('420982', 4, '安陆市', '420900', '432600'),
        ('420984', 4, '汉川市', '420900', '431600'),
        ('420985', 4, '其它区', '420900', ''),
        ('421000', 3, '荆州市', '420000', '434000'),
        ('421002', 4, '沙市区', '421000', '434000'),
        ('421003', 4, '荆州区', '421000', '434020'),
        ('421022', 4, '公安县', '421000', '434300'),
        ('421023', 4, '监利县', '421000', '433300'),
        ('421024', 4, '江陵县', '421000', '434100'),
        ('421081', 4, '石首市', '421000', '434400'),
        ('421083', 4, '洪湖市', '421000', '433200'),
        ('421087', 4, '松滋市', '421000', '434200'),
        ('421088', 4, '其它区', '421000', ''),
        ('421100', 3, '黄冈市', '420000', '438000'),
        ('421102', 4, '黄州区', '421100', '438000'),
        ('421121', 4, '团风县', '421100', '438000'),
        ('421122', 4, '红安县', '421100', '431500'),
        ('421123', 4, '罗田县', '421100', '438600'),
        ('421124', 4, '英山县', '421100', '438700'),
        ('421125', 4, '浠水县', '421100', '438200'),
        ('421126', 4, '蕲春县', '421100', '436300'),
        ('421127', 4, '黄梅县', '421100', '435500'),
        ('421181', 4, '麻城市', '421100', '438300'),
        ('421182', 4, '武穴市', '421100', '435400'),
        ('421183', 4, '其它区', '421100', ''),
        ('421200', 3, '咸宁市', '420000', '437100'),
        ('421202', 4, '咸安区', '421200', '437000'),
        ('421221', 4, '嘉鱼县', '421200', '437200'),
        ('421222', 4, '通城县', '421200', '437400'),
        ('421223', 4, '崇阳县', '421200', '437500'),
        ('421224', 4, '通山县', '421200', '437600'),
        ('421281', 4, '赤壁市', '421200', '437300'),
        ('421282', 4, '温泉城区', '421200', ''),
        ('421283', 4, '其它区', '421200', ''),
        ('421300', 3, '随州市', '420000', '441300'),
        ('421302', 4, '曾都区', '421300', '441300'),
        ('421321', 4, '随县', '421300', '441300'),
        ('421381', 4, '广水市', '421300', '432700'),
        ('421382', 4, '其它区', '421300', ''),
        ('422800', 3, '恩施土家族苗族自治州', '420000', ''),
        ('422801', 4, '恩施市', '422800', '445000'),
        ('422802', 4, '利川市', '422800', '445400'),
        ('422822', 4, '建始县', '422800', '445300'),
        ('422823', 4, '巴东县', '422800', '444300'),
        ('422825', 4, '宣恩县', '422800', '445500'),
        ('422826', 4, '咸丰县', '422800', '445600'),
        ('422827', 4, '来凤县', '422800', '445700'),
        ('422828', 4, '鹤峰县', '422800', '445800'),
        ('422829', 4, '其它区', '422800', ''),
        ('429004', 4, '仙桃市', '420000', '433000'),
        ('429005', 4, '潜江市', '420000', '433100'),
        ('429006', 4, '天门市', '420000', '431700'),
        ('429021', 4, '神农架林区', '420000', '442400'),
        ('430000', 2, '湖南省', '1', ''),
        ('430100', 3, '长沙市', '430000', '\r\n410000'),
        ('430102', 4, '芙蓉区', '430100', '410006'),
        ('430103', 4, '天心区', '430100', '410002'),
        ('430104', 4, '岳麓区', '430100', '410006'),
        ('430105', 4, '开福区', '430100', '410005'),
        ('430111', 4, '雨花区', '430100', '410007'),
        ('430121', 4, '长沙县', '430100', '410100'),
        ('430122', 4, '望城县', '430100', '410200'),
        ('430124', 4, '宁乡县', '430100', '410600'),
        ('430181', 4, '浏阳市', '430100', '410300'),
        ('430182', 4, '其它区', '430100', ''),
        ('430200', 3, '株洲市', '430000', '412000'),
        ('430202', 4, '荷塘区', '430200', '412000'),
        ('430203', 4, '芦淞区', '430200', '412000'),
        ('430204', 4, '石峰区', '430200', '412005'),
        ('430211', 4, '天元区', '430200', '412000'),
        ('430221', 4, '株洲县', '430200', '412100'),
        ('430223', 4, '攸县', '430200', '412300'),
        ('430224', 4, '茶陵县', '430200', '412400'),
        ('430225', 4, '炎陵县', '430200', '412500'),
        ('430281', 4, '醴陵市', '430200', '412200'),
        ('430282', 4, '其它区', '430200', ''),
        ('430300', 3, '湘潭市', '430000', '411100'),
        ('430302', 4, '雨湖区', '430300', '411100'),
        ('430304', 4, '岳塘区', '430300', '411101'),
        ('430321', 4, '湘潭县', '430300', '411200'),
        ('430381', 4, '湘乡市', '430300', '411400'),
        ('430382', 4, '韶山市', '430300', '411300'),
        ('430383', 4, '其它区', '430300', ''),
        ('430400', 3, '衡阳市', '430000', '421000'),
        ('430405', 4, '珠晖区', '430400', '421002'),
        ('430406', 4, '雁峰区', '430400', '421001'),
        ('430407', 4, '石鼓区', '430400', '421001'),
        ('430408', 4, '蒸湘区', '430400', '421001'),
        ('430412', 4, '南岳区', '430400', '421900'),
        ('430421', 4, '衡阳县', '430400', '421200'),
        ('430422', 4, '衡南县', '430400', '421100'),
        ('430423', 4, '衡山县', '430400', '421300'),
        ('430424', 4, '衡东县', '430400', '421400'),
        ('430426', 4, '祁东县', '430400', '421600'),
        ('430481', 4, '耒阳市', '430400', '421800'),
        ('430482', 4, '常宁市', '430400', '421500'),
        ('430483', 4, '其它区', '430400', ''),
        ('430500', 3, '邵阳市', '430000', '422000'),
        ('430502', 4, '双清区', '430500', '422001'),
        ('430503', 4, '大祥区', '430500', '422000'),
        ('430511', 4, '北塔区', '430500', '422001'),
        ('430521', 4, '邵东县', '430500', '422800'),
        ('430522', 4, '新邵县', '430500', '422900'),
        ('430523', 4, '邵阳县', '430500', '422100'),
        ('430524', 4, '隆回县', '430500', '422200'),
        ('430525', 4, '洞口县', '430500', '422300'),
        ('430527', 4, '绥宁县', '430500', '422600'),
        ('430528', 4, '新宁县', '430500', '422700'),
        ('430529', 4, '城步苗族自治县', '430500', '422500'),
        ('430581', 4, '武冈市', '430500', '422400'),
        ('430582', 4, '其它区', '430500', ''),
        ('430600', 3, '岳阳市', '430000', '414000'),
        ('430602', 4, '岳阳楼区', '430600', '414000'),
        ('430603', 4, '云溪区', '430600', '414003'),
        ('430611', 4, '君山区', '430600', '414005'),
        ('430621', 4, '岳阳县', '430600', '414100'),
        ('430623', 4, '华容县', '430600', '414200'),
        ('430624', 4, '湘阴县', '430600', '414600'),
        ('430626', 4, '平江县', '430600', '410400'),
        ('430681', 4, '汨罗市', '430600', '414400'),
        ('430682', 4, '临湘市', '430600', '414300'),
        ('430683', 4, '其它区', '430600', ''),
        ('430700', 3, '常德市', '430000', '415000'),
        ('430702', 4, '武陵区', '430700', '415000'),
        ('430703', 4, '鼎城区', '430700', '415100'),
        ('430721', 4, '安乡县', '430700', '415600'),
        ('430722', 4, '汉寿县', '430700', '415900'),
        ('430723', 4, '澧县', '430700', '415500'),
        ('430724', 4, '临澧县', '430700', '415200'),
        ('430725', 4, '桃源县', '430700', '415700'),
        ('430726', 4, '石门县', '430700', '415300'),
        ('430781', 4, '津市市', '430700', '415400'),
        ('430782', 4, '其它区', '430700', ''),
        ('430800', 3, '张家界市', '430000', '427000'),
        ('430802', 4, '永定区', '430800', '427000'),
        ('430811', 4, '武陵源区', '430800', '427400'),
        ('430821', 4, '慈利县', '430800', '427200'),
        ('430822', 4, '桑植县', '430800', '427100'),
        ('430823', 4, '其它区', '430800', ''),
        ('430900', 3, '益阳市', '430000', '413000'),
        ('430902', 4, '资阳区', '430900', '413000'),
        ('430903', 4, '赫山区', '430900', '413002'),
        ('430921', 4, '南县', '430900', '413200'),
        ('430922', 4, '桃江县', '430900', '413400'),
        ('430923', 4, '安化县', '430900', '413500'),
        ('430981', 4, '沅江市', '430900', '413100'),
        ('430982', 4, '其它区', '430900', ''),
        ('431000', 3, '郴州市', '430000', '423000'),
        ('431002', 4, '北湖区', '431000', '423000'),
        ('431003', 4, '苏仙区', '431000', '423000'),
        ('431021', 4, '桂阳县', '431000', '424400'),
        ('431022', 4, '宜章县', '431000', '424200'),
        ('431023', 4, '永兴县', '431000', '423300'),
        ('431024', 4, '嘉禾县', '431000', '424500'),
        ('431025', 4, '临武县', '431000', '424300'),
        ('431026', 4, '汝城县', '431000', '424100'),
        ('431027', 4, '桂东县', '431000', '423500'),
        ('431028', 4, '安仁县', '431000', '423600'),
        ('431081', 4, '资兴市', '431000', '423400'),
        ('431082', 4, '其它区', '431000', ''),
        ('431100', 3, '永州市', '430000', '425000'),
        ('431102', 4, '零陵区', '431100', '425007'),
        ('431103', 4, '冷水滩区', '431100', '425000'),
        ('431121', 4, '祁阳县', '431100', '426100'),
        ('431122', 4, '东安县', '431100', '425900'),
        ('431123', 4, '双牌县', '431100', '425200'),
        ('431124', 4, '道县', '431100', '425300'),
        ('431125', 4, '江永县', '431100', '425400'),
        ('431126', 4, '宁远县', '431100', '425600'),
        ('431127', 4, '蓝山县', '431100', '\r\n425800'),
        ('431128', 4, '新田县', '431100', '425700'),
        ('431129', 4, '江华瑶族自治县', '431100', '425500'),
        ('431130', 4, '其它区', '431100', ''),
        ('431200', 3, '怀化市', '430000', '418000'),
        ('431202', 4, '鹤城区', '431200', '418000'),
        ('431221', 4, '中方县', '431200', '418005'),
        ('431222', 4, '沅陵县', '431200', '419600'),
        ('431223', 4, '辰溪县', '431200', '419500'),
        ('431224', 4, '溆浦县', '431200', '419300'),
        ('431225', 4, '会同县', '431200', '418300'),
        ('431226', 4, '麻阳苗族自治县', '431200', '419400'),
        ('431227', 4, '新晃侗族自治县', '431200', '419200'),
        ('431228', 4, '芷江侗族自治县', '431200', '419100'),
        ('431229', 4, '靖州苗族侗族自治县', '431200', '418400'),
        ('431230', 4, '通道侗族自治县', '431200', '418500'),
        ('431281', 4, '洪江市', '431200', '418200'),
        ('431282', 4, '其它区', '431200', ''),
        ('431300', 3, '娄底市', '430000', '417000'),
        ('431302', 4, '娄星区', '431300', '417000');
        INSERT INTO {{%area_code}} (`id`, `type`, `name`, `parent_id`, `zip`) VALUES
        ('431321', 4, '双峰县', '431300', '417700'),
        ('431322', 4, '新化县', '431300', '417600'),
        ('431381', 4, '冷水江市', '431300', '417500'),
        ('431382', 4, '涟源市', '431300', '417100'),
        ('431383', 4, '其它区', '431300', ''),
        ('433100', 3, '湘西土家族苗族自治州', '430000', '416000'),
        ('433101', 4, '吉首市', '433100', '416000'),
        ('433122', 4, '泸溪县', '433100', '416100'),
        ('433123', 4, '凤凰县', '433100', '416200'),
        ('433124', 4, '花垣县', '433100', '416400'),
        ('433125', 4, '保靖县', '433100', '416500'),
        ('433126', 4, '古丈县', '433100', '416300'),
        ('433127', 4, '永顺县', '433100', '416700'),
        ('433130', 4, '龙山县', '433100', '416800'),
        ('433131', 4, '其它区', '433100', ''),
        ('440000', 2, '广东省', '1', ''),
        ('440100', 3, '广州市', '440000', '510000'),
        ('440103', 4, '荔湾区', '440100', '510145'),
        ('440104', 4, '越秀区', '440100', '510180'),
        ('440105', 4, '海珠区', '440100', '510220'),
        ('440106', 4, '天河区', '440100', '510510'),
        ('440111', 4, '白云区', '440100', '510440'),
        ('440112', 4, '黄埔区', '440100', '510700'),
        ('440113', 4, '番禺区', '440100', '511400'),
        ('440114', 4, '花都区', '440100', '510800'),
        ('440115', 4, '南沙区', '440100', ''),
        ('440116', 4, '萝岗区', '440100', ''),
        ('440183', 4, '增城市', '440100', '511300'),
        ('440184', 4, '从化市', '440100', '510900'),
        ('440188', 4, '东山区', '440100', ''),
        ('440189', 4, '其它区', '440100', ''),
        ('440200', 3, '韶关市', '440000', '512000'),
        ('440203', 4, '武江区', '440200', '512026'),
        ('440204', 4, '浈江区', '440200', '512023'),
        ('440205', 4, '曲江区', '440200', '512100'),
        ('440222', 4, '始兴县', '440200', '512500'),
        ('440224', 4, '仁化县', '440200', '512300'),
        ('440229', 4, '翁源县', '440200', '512600'),
        ('440232', 4, '乳源瑶族自治县', '440200', '512700'),
        ('440233', 4, '新丰县', '440200', '511100'),
        ('440281', 4, '乐昌市', '440200', '512200'),
        ('440282', 4, '南雄市', '440200', '512400'),
        ('440283', 4, '其它区', '440200', ''),
        ('440300', 3, '深圳市', '440000', '518000'),
        ('440303', 4, '罗湖区', '440300', '518002'),
        ('440304', 4, '福田区', '440300', '518031'),
        ('440305', 4, '南山区', '440300', '518052'),
        ('440306', 4, '宝安区', '440300', '518101'),
        ('440307', 4, '龙岗区', '440300', '518116'),
        ('440308', 4, '盐田区', '440300', '518083'),
        ('440309', 4, '其它区', '440300', ''),
        ('440400', 3, '珠海市', '440000', '519000'),
        ('440402', 4, '香洲区', '440400', '519000'),
        ('440403', 4, '斗门区', '440400', '519100'),
        ('440404', 4, '金湾区', '440400', '519090'),
        ('440486', 4, '金唐区', '440400', ''),
        ('440487', 4, '南湾区', '440400', ''),
        ('440488', 4, '其它区', '440400', ''),
        ('440500', 3, '汕头市', '440000', '515000'),
        ('440507', 4, '龙湖区', '440500', '515041'),
        ('440511', 4, '金平区', '440500', '515041'),
        ('440512', 4, '濠江区', '440500', '515071'),
        ('440513', 4, '潮阳区', '440500', '515100'),
        ('440514', 4, '潮南区', '440500', '515144'),
        ('440515', 4, '澄海区', '440500', '515800'),
        ('440523', 4, '南澳县', '440500', '515900'),
        ('440524', 4, '其它区', '440500', ''),
        ('440600', 3, '佛山市', '440000', '528000'),
        ('440604', 4, '禅城区', '440600', '528000'),
        ('440605', 4, '南海区', '440600', '528200'),
        ('440606', 4, '顺德区', '440600', '528300'),
        ('440607', 4, '三水区', '440600', '528100'),
        ('440608', 4, '高明区', '440600', '528500'),
        ('440609', 4, '其它区', '440600', ''),
        ('440700', 3, '江门市', '440000', '529000'),
        ('440703', 4, '蓬江区', '440700', '529051'),
        ('440704', 4, '江海区', '440700', '529000'),
        ('440705', 4, '新会区', '440700', '529100'),
        ('440781', 4, '台山市', '440700', '529200'),
        ('440783', 4, '开平市', '440700', '529300'),
        ('440784', 4, '鹤山市', '440700', '529700'),
        ('440785', 4, '恩平市', '440700', '529400'),
        ('440786', 4, '其它区', '440700', ''),
        ('440800', 3, '湛江市', '440000', '524000'),
        ('440802', 4, '赤坎区', '440800', '524033'),
        ('440803', 4, '霞山区', '440800', '524002'),
        ('440804', 4, '坡头区', '440800', '524057'),
        ('440811', 4, '麻章区', '440800', '524003'),
        ('440823', 4, '遂溪县', '440800', '524300'),
        ('440825', 4, '徐闻县', '440800', '524100'),
        ('440881', 4, '廉江市', '440800', '524400'),
        ('440882', 4, '雷州市', '440800', '524200'),
        ('440883', 4, '吴川市', '440800', '524500'),
        ('440884', 4, '其它区', '440800', ''),
        ('440900', 3, '茂名市', '440000', '525000'),
        ('440902', 4, '茂南区', '440900', '525011'),
        ('440903', 4, '茂港区', '440900', '525027'),
        ('440923', 4, '电白县', '440900', '525400'),
        ('440981', 4, '高州市', '440900', '525200'),
        ('440982', 4, '化州市', '440900', '525100'),
        ('440983', 4, '信宜市', '440900', '525300'),
        ('440984', 4, '其它区', '440900', ''),
        ('441200', 3, '肇庆市', '440000', '526000'),
        ('441202', 4, '端州区', '441200', '526040'),
        ('441203', 4, '鼎湖区', '441200', '526070'),
        ('441223', 4, '广宁县', '441200', '526300'),
        ('441224', 4, '怀集县', '441200', '526400'),
        ('441225', 4, '封开县', '441200', '526500'),
        ('441226', 4, '德庆县', '441200', '526600'),
        ('441283', 4, '高要市', '441200', '526100'),
        ('441284', 4, '四会市', '441200', '526200'),
        ('441285', 4, '其它区', '441200', ''),
        ('441300', 3, '惠州市', '440000', '516000'),
        ('441302', 4, '惠城区', '441300', '516001'),
        ('441303', 4, '惠阳区', '441300', '516200'),
        ('441322', 4, '博罗县', '441300', '516100'),
        ('441323', 4, '惠东县', '441300', '516300'),
        ('441324', 4, '龙门县', '441300', '516800'),
        ('441325', 4, '其它区', '441300', ''),
        ('441400', 3, '梅州市', '440000', '514000'),
        ('441402', 4, '梅江区', '441400', '514000'),
        ('441421', 4, '梅县', '441400', '514700'),
        ('441422', 4, '大埔县', '441400', '514200'),
        ('441423', 4, '丰顺县', '441400', '514300'),
        ('441424', 4, '五华县', '441400', '514400'),
        ('441426', 4, '平远县', '441400', '514600'),
        ('441427', 4, '蕉岭县', '441400', '514100'),
        ('441481', 4, '兴宁市', '441400', '514500'),
        ('441482', 4, '其它区', '441400', ''),
        ('441500', 3, '汕尾市', '440000', '516600'),
        ('441502', 4, '城区', '441500', '516601'),
        ('441521', 4, '海丰县', '441500', '516400'),
        ('441523', 4, '陆河县', '441500', '516700'),
        ('441581', 4, '陆丰市', '441500', '516500'),
        ('441582', 4, '其它区', '441500', ''),
        ('441600', 3, '河源市', '440000', '517000'),
        ('441602', 4, '源城区', '441600', '517000'),
        ('441621', 4, '紫金县', '441600', '517400'),
        ('441622', 4, '龙川县', '441600', '517300'),
        ('441623', 4, '连平县', '441600', '517100'),
        ('441624', 4, '和平县', '441600', '517200'),
        ('441625', 4, '东源县', '441600', '517500'),
        ('441626', 4, '其它区', '441600', ''),
        ('441700', 3, '阳江市', '440000', '529500'),
        ('441702', 4, '江城区', '441700', '529525'),
        ('441721', 4, '阳西县', '441700', '529800'),
        ('441723', 4, '阳东县', '441700', '529931'),
        ('441781', 4, '阳春市', '441700', '529600'),
        ('441782', 4, '其它区', '441700', ''),
        ('441800', 3, '清远市', '440000', '511500'),
        ('441802', 4, '清城区', '441800', '511500'),
        ('441821', 4, '佛冈县', '441800', '511600'),
        ('441823', 4, '阳山县', '441800', '513100'),
        ('441825', 4, '连山壮族瑶族自治县', '441800', '513200'),
        ('441826', 4, '连南瑶族自治县', '441800', '513300'),
        ('441827', 4, '清新县', '441800', '511800'),
        ('441881', 4, '英德市', '441800', '513000'),
        ('441882', 4, '连州市', '441800', '513400'),
        ('441883', 4, '其它区', '441800', ''),
        ('441900', 3, '东莞市', '440000', '523000'),
        ('442000', 3, '中山市', '440000', '528400'),
        ('445100', 3, '潮州市', '440000', '521000'),
        ('445102', 4, '湘桥区', '445100', '521000'),
        ('445121', 4, '潮安县', '445100', '515600'),
        ('445122', 4, '饶平县', '445100', '515700'),
        ('445185', 4, '枫溪区', '445100', ''),
        ('445186', 4, '其它区', '445100', ''),
        ('445200', 3, '揭阳市', '440000', '522000'),
        ('445202', 4, '榕城区', '445200', '522095'),
        ('445221', 4, '揭东县', '445200', '515500'),
        ('445222', 4, '揭西县', '445200', '515400'),
        ('445224', 4, '惠来县', '445200', '515200'),
        ('445281', 4, '普宁市', '445200', '515300'),
        ('445284', 4, '东山区', '445200', ''),
        ('445285', 4, '其它区', '445200', ''),
        ('445300', 3, '云浮市', '440000', '527300'),
        ('445302', 4, '云城区', '445300', '527300'),
        ('445321', 4, '新兴县', '445300', '527400'),
        ('445322', 4, '郁南县', '445300', '527100'),
        ('445323', 4, '云安县', '445300', '527500'),
        ('445381', 4, '罗定市', '445300', '527200'),
        ('445382', 4, '其它区', '445300', ''),
        ('450000', 2, '广西壮族自治区', '1', ''),
        ('450100', 3, '南宁市', '450000', '530000'),
        ('450102', 4, '兴宁区', '450100', '530012'),
        ('450103', 4, '青秀区', '450100', '530022'),
        ('450105', 4, '江南区', '450100', '530031'),
        ('450107', 4, '西乡塘区', '450100', '530001'),
        ('450108', 4, '良庆区', '450100', '530200'),
        ('450109', 4, '邕宁区', '450100', '530200'),
        ('450122', 4, '武鸣县', '450100', '530100'),
        ('450123', 4, '隆安县', '450100', '532700'),
        ('450124', 4, '马山县', '450100', '530600'),
        ('450125', 4, '上林县', '450100', '530500'),
        ('450126', 4, '宾阳县', '450100', '530400'),
        ('450127', 4, '横县', '450100', '530300'),
        ('450128', 4, '其它区', '450100', ''),
        ('450200', 3, '柳州市', '450000', '545000'),
        ('450202', 4, '城中区', '450200', '545001'),
        ('450203', 4, '鱼峰区', '450200', '545005'),
        ('450204', 4, '柳南区', '450200', '545005'),
        ('450205', 4, '柳北区', '450200', '545001'),
        ('450221', 4, '柳江县', '450200', '545100'),
        ('450222', 4, '柳城县', '450200', '545200'),
        ('450223', 4, '鹿寨县', '450200', '545600'),
        ('450224', 4, '融安县', '450200', '545400'),
        ('450225', 4, '融水苗族自治县', '450200', '545300'),
        ('450226', 4, '三江侗族自治县', '450200', '545500'),
        ('450227', 4, '其它区', '450200', ''),
        ('450300', 3, '桂林市', '450000', '541000'),
        ('450302', 4, '秀峰区', '450300', '541001'),
        ('450303', 4, '叠彩区', '450300', '541001'),
        ('450304', 4, '象山区', '450300', '541002'),
        ('450305', 4, '七星区', '450300', '541004'),
        ('450311', 4, '雁山区', '450300', '541006'),
        ('450321', 4, '阳朔县', '450300', '541900'),
        ('450322', 4, '临桂县', '450300', '541100'),
        ('450323', 4, '灵川县', '450300', '541200'),
        ('450324', 4, '全州县', '450300', '541500'),
        ('450325', 4, '兴安县', '450300', '541300'),
        ('450326', 4, '永福县', '450300', '541800'),
        ('450327', 4, '灌阳县', '450300', '541600'),
        ('450328', 4, '龙胜各族自治县', '450300', '541700'),
        ('450329', 4, '资源县', '450300', '541400'),
        ('450330', 4, '平乐县', '450300', '542400'),
        ('450331', 4, '荔浦县', '450300', '546600'),
        ('450332', 4, '恭城瑶族自治县', '450300', '542500'),
        ('450333', 4, '其它区', '450300', ''),
        ('450400', 3, '梧州市', '450000', '543000'),
        ('450403', 4, '万秀区', '450400', '543000'),
        ('450404', 4, '蝶山区', '450400', '543002'),
        ('450405', 4, '长洲区', '450400', '543002'),
        ('450421', 4, '苍梧县', '450400', '543100'),
        ('450422', 4, '藤县', '450400', '543300'),
        ('450423', 4, '蒙山县', '450400', '546700'),
        ('450481', 4, '岑溪市', '450400', '543200'),
        ('450482', 4, '其它区', '450400', ''),
        ('450500', 3, '北海市', '450000', '536000'),
        ('450502', 4, '海城区', '450500', '536000'),
        ('450503', 4, '银海区', '450500', '536000'),
        ('450512', 4, '铁山港区', '450500', '536017'),
        ('450521', 4, '合浦县', '450500', '536100'),
        ('450522', 4, '其它区', '450500', ''),
        ('450600', 3, '防城港市', '450000', '538000'),
        ('450602', 4, '港口区', '450600', '538001'),
        ('450603', 4, '防城区', '450600', '538021'),
        ('450621', 4, '上思县', '450600', '535500'),
        ('450681', 4, '东兴市', '450600', '538100'),
        ('450682', 4, '其它区', '450600', ''),
        ('450700', 3, '钦州市', '450000', '535000'),
        ('450702', 4, '钦南区', '450700', '535000'),
        ('450703', 4, '钦北区', '450700', '535000'),
        ('450721', 4, '灵山县', '450700', '535400'),
        ('450722', 4, '浦北县', '450700', '535300'),
        ('450723', 4, '其它区', '450700', ''),
        ('450800', 3, '贵港市', '450000', '537100'),
        ('450802', 4, '港北区', '450800', '537100'),
        ('450803', 4, '港南区', '450800', '537132'),
        ('450804', 4, '覃塘区', '450800', '537121'),
        ('450821', 4, '平南县', '450800', '537300'),
        ('450881', 4, '桂平市', '450800', '537200'),
        ('450882', 4, '其它区', '450800', ''),
        ('450900', 3, '玉林市', '450000', '537000'),
        ('450902', 4, '玉州区', '450900', '537000'),
        ('450921', 4, '容县', '450900', '537500'),
        ('450922', 4, '陆川县', '450900', '537700'),
        ('450923', 4, '博白县', '450900', '537600'),
        ('450924', 4, '兴业县', '450900', '537800'),
        ('450981', 4, '北流市', '450900', '537400'),
        ('450982', 4, '其它区', '450900', ''),
        ('451000', 3, '百色市', '450000', '533000'),
        ('451002', 4, '右江区', '451000', '533000'),
        ('451021', 4, '田阳县', '451000', '533600'),
        ('451022', 4, '田东县', '451000', '531500'),
        ('451023', 4, '平果县', '451000', '531400'),
        ('451024', 4, '德保县', '451000', '533700'),
        ('451025', 4, '靖西县', '451000', '533800'),
        ('451026', 4, '那坡县', '451000', '533900'),
        ('451027', 4, '凌云县', '451000', '533100'),
        ('451028', 4, '乐业县', '451000', '533200'),
        ('451029', 4, '田林县', '451000', '533300'),
        ('451030', 4, '西林县', '451000', '533500'),
        ('451031', 4, '隆林各族自治县', '451000', '533400'),
        ('451032', 4, '其它区', '451000', ''),
        ('451100', 3, '贺州市', '450000', '542800'),
        ('451102', 4, '八步区', '451100', '542800'),
        ('451121', 4, '昭平县', '451100', '546800'),
        ('451122', 4, '钟山县', '451100', '542600'),
        ('451123', 4, '富川瑶族自治县', '451100', '542700'),
        ('451124', 4, '其它区', '451100', ''),
        ('451200', 3, '河池市', '450000', '547000'),
        ('451202', 4, '金城江区', '451200', '547000'),
        ('451221', 4, '南丹县', '451200', '547200'),
        ('451222', 4, '天峨县', '451200', '547300'),
        ('451223', 4, '凤山县', '451200', '547600'),
        ('451224', 4, '东兰县', '451200', '547400'),
        ('451225', 4, '罗城仫佬族自治县', '451200', '546400'),
        ('451226', 4, '环江毛南族自治县', '451200', '547100'),
        ('451227', 4, '巴马瑶族自治县', '451200', '547500'),
        ('451228', 4, '都安瑶族自治县', '451200', '530700'),
        ('451229', 4, '大化瑶族自治县', '451200', '530800'),
        ('451281', 4, '宜州市', '451200', '546300'),
        ('451282', 4, '其它区', '451200', ''),
        ('451300', 3, '来宾市', '450000', '546100'),
        ('451302', 4, '兴宾区', '451300', '546100'),
        ('451321', 4, '忻城县', '451300', '546200'),
        ('451322', 4, '象州县', '451300', '545800'),
        ('451323', 4, '武宣县', '451300', '545900'),
        ('451324', 4, '金秀瑶族自治县', '451300', '545700'),
        ('451381', 4, '合山市', '451300', '546500'),
        ('451382', 4, '其它区', '451300', ''),
        ('451400', 3, '崇左市', '450000', '532200'),
        ('451402', 4, '江洲区', '451400', '532200'),
        ('451421', 4, '扶绥县', '451400', '532100'),
        ('451422', 4, '宁明县', '451400', '532500'),
        ('451423', 4, '龙州县', '451400', '532400'),
        ('451424', 4, '大新县', '451400', '532300'),
        ('451425', 4, '天等县', '451400', '532800'),
        ('451481', 4, '凭祥市', '451400', '532600'),
        ('451482', 4, '其它区', '451400', ''),
        ('460000', 2, '海南省', '1', ''),
        ('460100', 3, '海口市', '460000', '570000'),
        ('460105', 4, '秀英区', '460100', '570311'),
        ('460106', 4, '龙华区', '460100', '570105'),
        ('460107', 4, '琼山区', '460100', '571100'),
        ('460108', 4, '美兰区', '460100', '570203'),
        ('460109', 4, '其它区', '460100', ''),
        ('460200', 3, '三亚市', '460000', '572000'),
        ('469001', 4, '五指山市', '460000', '572200'),
        ('469002', 4, '琼海市', '460000', '571400'),
        ('469003', 4, '儋州市', '460000', '571700'),
        ('469005', 4, '文昌市', '460000', '571300'),
        ('469006', 4, '万宁市', '460000', '571500'),
        ('469007', 4, '东方市', '460000', '572600'),
        ('469025', 4, '定安县', '460000', '571200'),
        ('469026', 4, '屯昌县', '460000', '571600'),
        ('469027', 4, '澄迈县', '460000', '571900'),
        ('469028', 4, '临高县', '460000', '571800'),
        ('469030', 4, '白沙黎族自治县', '460000', '572800'),
        ('469031', 4, '昌江黎族自治县', '460000', '572700'),
        ('469033', 4, '乐东黎族自治县', '460000', '572500'),
        ('469034', 4, '陵水黎族自治县', '460000', '572400'),
        ('469035', 4, '保亭黎族苗族自治县', '460000', '572300'),
        ('469036', 4, '琼中黎族苗族自治县', '460000', '572900'),
        ('469037', 4, '西沙群岛', '460000', '573100'),
        ('469038', 4, '南沙群岛', '460000', '573100'),
        ('469039', 4, '中沙群岛的岛礁及其海域', '460000', '573100'),
        ('471004', 4, '高新区', '410300', ''),
        ('471005', 4, '其它区', '410300', ''),
        ('500000', 2, '重庆', '1', ''),
        ('500100', 3, '重庆市', '500000', '400000'),
        ('500101', 4, '万州区', '500100', '404000'),
        ('500102', 4, '涪陵区', '500100', '408000'),
        ('500103', 4, '渝中区', '500100', '400012'),
        ('500104', 4, '大渡口区', '500100', '400084'),
        ('500105', 4, '江北区', '500100', '400021'),
        ('500106', 4, '沙坪坝区', '500100', '400020'),
        ('500107', 4, '九龙坡区', '500100', '400039'),
        ('500108', 4, '南岸区', '500100', '400060'),
        ('500109', 4, '北碚区', '500100', '400700'),
        ('500110', 4, '万盛区', '500100', '400800'),
        ('500111', 4, '双桥区', '500100', '400900'),
        ('500112', 4, '渝北区', '500100', '401120'),
        ('500113', 4, '巴南区', '500100', '401320'),
        ('500114', 4, '黔江区', '500100', '409700'),
        ('500115', 4, '长寿区', '500100', '401220'),
        ('500222', 4, '綦江县', '500100', '401420'),
        ('500223', 4, '潼南县', '500100', '402660'),
        ('500224', 4, '铜梁县', '500100', '402560'),
        ('500225', 4, '大足县', '500100', '402360'),
        ('500226', 4, '荣昌县', '500100', '402460'),
        ('500227', 4, '璧山县', '500100', '402760'),
        ('500228', 4, '梁平县', '500100', '405200'),
        ('500229', 4, '城口县', '500100', '405900'),
        ('500230', 4, '丰都县', '500100', '408200'),
        ('500231', 4, '垫江县', '500100', '408300'),
        ('500232', 4, '武隆县', '500100', '408500'),
        ('500233', 4, '忠县', '500100', '404300'),
        ('500234', 4, '开县', '500100', '405400'),
        ('500235', 4, '云阳县', '500100', '404500'),
        ('500236', 4, '奉节县', '500100', '404600'),
        ('500237', 4, '巫山县', '500100', '404700'),
        ('500238', 4, '巫溪县', '500100', '405800'),
        ('500240', 4, '石柱土家族自治县', '500100', '409100'),
        ('500241', 4, '秀山土家族苗族自治县', '500100', '409900'),
        ('500242', 4, '酉阳土家族苗族自治县', '500100', '409800'),
        ('500243', 4, '彭水苗族土家族自治县', '500100', '409600'),
        ('500381', 4, '江津区', '500100', '402260'),
        ('500382', 4, '合川区', '500100', '401520'),
        ('500383', 4, '永川区', '500100', '402160'),
        ('500384', 4, '南川区', '500100', '408400'),
        ('500385', 4, '其它区', '500100', ''),
        ('510000', 2, '四川省', '1', ''),
        ('510100', 3, '成都市', '510000', '610000'),
        ('510104', 4, '锦江区', '510100', '610011'),
        ('510105', 4, '青羊区', '510100', '610031'),
        ('510106', 4, '金牛区', '510100', '610036'),
        ('510107', 4, '武侯区', '510100', '610041'),
        ('510108', 4, '成华区', '510100', '610066'),
        ('510112', 4, '龙泉驿区', '510100', '610100'),
        ('510113', 4, '青白江区', '510100', '610300'),
        ('510114', 4, '新都区', '510100', '610500'),
        ('510115', 4, '温江区', '510100', '611130'),
        ('510121', 4, '金堂县', '510100', '610400'),
        ('510122', 4, '双流县', '510100', '610200'),
        ('510124', 4, '郫县', '510100', '611730'),
        ('510129', 4, '大邑县', '510100', '611330'),
        ('510131', 4, '蒲江县', '510100', '611630'),
        ('510132', 4, '新津县', '510100', '611430'),
        ('510181', 4, '都江堰市', '510100', '611830'),
        ('510182', 4, '彭州市', '510100', '611930'),
        ('510183', 4, '邛崃市', '510100', '611530'),
        ('510184', 4, '崇州市', '510100', '611230'),
        ('510185', 4, '其它区', '510100', ''),
        ('510300', 3, '自贡市', '510000', '643000'),
        ('510302', 4, '自流井区', '510300', '643000'),
        ('510303', 4, '贡井区', '510300', '643020'),
        ('510304', 4, '大安区', '510300', '643010'),
        ('510311', 4, '沿滩区', '510300', '643030'),
        ('510321', 4, '荣县', '510300', '643100'),
        ('510322', 4, '富顺县', '510300', '643200'),
        ('510323', 4, '其它区', '510300', ''),
        ('510400', 3, '攀枝花市', '510000', '617000'),
        ('510402', 4, '东区', '510400', '617067'),
        ('510403', 4, '西区', '510400', '617012'),
        ('510411', 4, '仁和区', '510400', '617061'),
        ('510421', 4, '米易县', '510400', '617200'),
        ('510422', 4, '盐边县', '510400', '617100'),
        ('510423', 4, '其它区', '510400', ''),
        ('510500', 3, '泸州市', '510000', '646000'),
        ('510502', 4, '江阳区', '510500', '646000'),
        ('510503', 4, '纳溪区', '510500', '646300'),
        ('510504', 4, '龙马潭区', '510500', '646000'),
        ('510521', 4, '泸县', '510500', '646100'),
        ('510522', 4, '合江县', '510500', '646200'),
        ('510524', 4, '叙永县', '510500', '\r\n646400'),
        ('510525', 4, '古蔺县', '510500', '646500'),
        ('510526', 4, '其它区', '510500', ''),
        ('510600', 3, '德阳市', '510000', '618000'),
        ('510603', 4, '旌阳区', '510600', '618000'),
        ('510623', 4, '中江县', '510600', '618300'),
        ('510626', 4, '罗江县', '510600', '618500'),
        ('510681', 4, '广汉市', '510600', '618300'),
        ('510682', 4, '什邡市', '510600', '618400'),
        ('510683', 4, '绵竹市', '510600', '618200'),
        ('510684', 4, '其它区', '510600', ''),
        ('510700', 3, '绵阳市', '510000', '621000'),
        ('510703', 4, '涪城区', '510700', '621000'),
        ('510704', 4, '游仙区', '510700', '621022'),
        ('510722', 4, '三台县', '510700', '621100'),
        ('510723', 4, '盐亭县', '510700', '621600'),
        ('510724', 4, '安县', '510700', '622650'),
        ('510725', 4, '梓潼县', '510700', '622150'),
        ('510726', 4, '北川羌族自治县', '510700', '622750'),
        ('510727', 4, '平武县', '510700', '621550'),
        ('510751', 4, '高新区', '510700', ''),
        ('510781', 4, '江油市', '510700', '621700'),
        ('510782', 4, '其它区', '510700', ''),
        ('510800', 3, '广元市', '510000', '628000'),
        ('510802', 4, '利州区', '510800', '628017'),
        ('510811', 4, '元坝区', '510800', '628021'),
        ('510812', 4, '朝天区', '510800', '628012'),
        ('510821', 4, '旺苍县', '510800', '628200'),
        ('510822', 4, '青川县', '510800', '628100'),
        ('510823', 4, '剑阁县', '510800', '628300'),
        ('510824', 4, '苍溪县', '510800', '628400'),
        ('510825', 4, '其它区', '510800', ''),
        ('510900', 3, '遂宁市', '510000', '629000'),
        ('510903', 4, '船山区', '510900', '629000'),
        ('510904', 4, '安居区', '510900', '629000'),
        ('510921', 4, '蓬溪县', '510900', '629100'),
        ('510922', 4, '射洪县', '510900', '629200'),
        ('510923', 4, '大英县', '510900', '629300'),
        ('510924', 4, '其它区', '510900', ''),
        ('511000', 3, '内江市', '510000', '641000'),
        ('511002', 4, '市中区', '511000', '641000'),
        ('511011', 4, '东兴区', '511000', '641100'),
        ('511024', 4, '威远县', '511000', '642450'),
        ('511025', 4, '资中县', '511000', '641200'),
        ('511028', 4, '隆昌县', '511000', '642150'),
        ('511029', 4, '其它区', '511000', ''),
        ('511100', 3, '乐山市', '510000', '614000'),
        ('511102', 4, '市中区', '511100', '614000'),
        ('511111', 4, '沙湾区', '511100', '614900'),
        ('511112', 4, '五通桥区', '511100', '614800'),
        ('511113', 4, '金口河区', '511100', '614700'),
        ('511123', 4, '犍为县', '511100', '614400'),
        ('511124', 4, '井研县', '511100', '613100'),
        ('511126', 4, '夹江县', '511100', '614100'),
        ('511129', 4, '沐川县', '511100', '614500'),
        ('511132', 4, '峨边彝族自治县', '511100', '614300'),
        ('511133', 4, '马边彝族自治县', '511100', '614600'),
        ('511181', 4, '峨眉山市', '511100', '614200'),
        ('511182', 4, '其它区', '511100', ''),
        ('511300', 3, '南充市', '510000', '637000'),
        ('511302', 4, '顺庆区', '511300', '637500'),
        ('511303', 4, '高坪区', '511300', '637100'),
        ('511304', 4, '嘉陵区', '511300', '637900'),
        ('511321', 4, '南部县', '511300', '637300'),
        ('511322', 4, '营山县', '511300', '638150'),
        ('511323', 4, '蓬安县', '511300', '638250'),
        ('511324', 4, '仪陇县', '511300', '637600'),
        ('511325', 4, '西充县', '511300', '637200'),
        ('511381', 4, '阆中市', '511300', '637400'),
        ('511382', 4, '其它区', '511300', ''),
        ('511400', 3, '眉山市', '510000', '620000'),
        ('511402', 4, '东坡区', '511400', '620010'),
        ('511421', 4, '仁寿县', '511400', '620500'),
        ('511422', 4, '彭山县', '511400', '620860'),
        ('511423', 4, '洪雅县', '511400', '620360'),
        ('511424', 4, '丹棱县', '511400', '620200'),
        ('511425', 4, '青神县', '511400', '620460'),
        ('511426', 4, '其它区', '511400', ''),
        ('511500', 3, '宜宾市', '510000', '644000'),
        ('511502', 4, '翠屏区', '511500', '644000'),
        ('511521', 4, '宜宾县', '511500', '644600'),
        ('511522', 4, '南溪县', '511500', '644100'),
        ('511523', 4, '江安县', '511500', '644200'),
        ('511524', 4, '长宁县', '511500', '644300'),
        ('511525', 4, '高县', '511500', '645150'),
        ('511526', 4, '珙县', '511500', '644500'),
        ('511527', 4, '筠连县', '511500', '645250'),
        ('511528', 4, '兴文县', '511500', '644400'),
        ('511529', 4, '屏山县', '511500', '645350'),
        ('511530', 4, '其它区', '511500', ''),
        ('511600', 3, '广安市', '510000', '638000'),
        ('511602', 4, '广安区', '511600', '638550'),
        ('511621', 4, '岳池县', '511600', '638300'),
        ('511622', 4, '武胜县', '511600', '638420'),
        ('511623', 4, '邻水县', '511600', '638520'),
        ('511681', 4, '华蓥市', '511600', '638650'),
        ('511682', 4, '市辖区', '511600', ''),
        ('511683', 4, '其它区', '511600', ''),
        ('511700', 3, '达州市', '510000', '635000'),
        ('511702', 4, '通川区', '511700', '635000'),
        ('511721', 4, '达县', '511700', '635006'),
        ('511722', 4, '宣汉县', '511700', '636150'),
        ('511723', 4, '开江县', '511700', '636250'),
        ('511724', 4, '大竹县', '511700', '635100'),
        ('511725', 4, '渠县', '511700', '635200'),
        ('511781', 4, '万源市', '511700', '636350'),
        ('511782', 4, '其它区', '511700', ''),
        ('511800', 3, '雅安市', '510000', '625000'),
        ('511802', 4, '雨城区', '511800', '625000'),
        ('511821', 4, '名山县', '511800', '625100'),
        ('511822', 4, '荥经县', '511800', '625200'),
        ('511823', 4, '汉源县', '511800', '625300'),
        ('511824', 4, '石棉县', '511800', '625400'),
        ('511825', 4, '天全县', '511800', '625500'),
        ('511826', 4, '芦山县', '511800', '625600'),
        ('511827', 4, '宝兴县', '511800', '625700'),
        ('511828', 4, '其它区', '511800', ''),
        ('511900', 3, '巴中市', '510000', '636000'),
        ('511902', 4, '巴州区', '511900', '636601'),
        ('511921', 4, '通江县', '511900', '636700'),
        ('511922', 4, '南江县', '511900', '636600'),
        ('511923', 4, '平昌县', '511900', '636400'),
        ('511924', 4, '其它区', '511900', ''),
        ('512000', 3, '资阳市', '510000', '641300'),
        ('512002', 4, '雁江区', '512000', '641300'),
        ('512021', 4, '安岳县', '512000', '642350'),
        ('512022', 4, '乐至县', '512000', '641500'),
        ('512081', 4, '简阳市', '512000', '641400'),
        ('512082', 4, '其它区', '512000', ''),
        ('513200', 3, '阿坝藏族羌族自治州', '510000', ''),
        ('513221', 4, '汶川县', '513200', '623000'),
        ('513222', 4, '理县', '513200', '632100'),
        ('513223', 4, '茂县', '513200', '623200'),
        ('513224', 4, '松潘县', '513200', '623300'),
        ('513225', 4, '九寨沟县', '513200', '623400'),
        ('513226', 4, '金川县', '513200', '624100'),
        ('513227', 4, '小金县', '513200', '624200'),
        ('513228', 4, '黑水县', '513200', '623500'),
        ('513229', 4, '马尔康县', '513200', '624000'),
        ('513230', 4, '壤塘县', '513200', '624300'),
        ('513231', 4, '阿坝县', '513200', '624600'),
        ('513232', 4, '若尔盖县', '513200', '624500'),
        ('513233', 4, '红原县', '513200', '624400'),
        ('513234', 4, '其它区', '513200', ''),
        ('513300', 3, '甘孜藏族自治州', '510000', ''),
        ('513321', 4, '康定县', '513300', '626000'),
        ('513322', 4, '泸定县', '513300', '626100'),
        ('513323', 4, '丹巴县', '513300', '626300'),
        ('513324', 4, '九龙县', '513300', '626200'),
        ('513325', 4, '雅江县', '513300', '627450'),
        ('513326', 4, '道孚县', '513300', '626400'),
        ('513327', 4, '炉霍县', '513300', '626500'),
        ('513328', 4, '甘孜县', '513300', '626700'),
        ('513329', 4, '新龙县', '513300', '626800'),
        ('513330', 4, '德格县', '513300', '627250'),
        ('513331', 4, '白玉县', '513300', '627150'),
        ('513332', 4, '石渠县', '513300', '627350'),
        ('513333', 4, '色达县', '513300', '626600'),
        ('513334', 4, '理塘县', '513300', '627550'),
        ('513335', 4, '巴塘县', '513300', '627650'),
        ('513336', 4, '乡城县', '513300', '627850'),
        ('513337', 4, '稻城县', '513300', '627750'),
        ('513338', 4, '得荣县', '513300', '627950'),
        ('513339', 4, '其它区', '513300', ''),
        ('513400', 3, '凉山彝族自治州', '510000', ''),
        ('513401', 4, '西昌市', '513400', '615000'),
        ('513422', 4, '木里藏族自治县', '513400', '615800'),
        ('513423', 4, '盐源县', '513400', '615700'),
        ('513424', 4, '德昌县', '513400', '615500'),
        ('513425', 4, '会理县', '513400', '615100'),
        ('513426', 4, '会东县', '513400', '615200'),
        ('513427', 4, '宁南县', '513400', '615400'),
        ('513428', 4, '普格县', '513400', '615300'),
        ('513429', 4, '布拖县', '513400', '616350'),
        ('513430', 4, '金阳县', '513400', '616250'),
        ('513431', 4, '昭觉县', '513400', '616150'),
        ('513432', 4, '喜德县', '513400', '616750'),
        ('513433', 4, '冕宁县', '513400', '615600'),
        ('513434', 4, '越西县', '513400', '616650'),
        ('513435', 4, '甘洛县', '513400', '616850'),
        ('513436', 4, '美姑县', '513400', '616450'),
        ('513437', 4, '雷波县', '513400', '616550'),
        ('513438', 4, '其它区', '513400', ''),
        ('520000', 2, '贵州省', '1', ''),
        ('520100', 3, '贵阳市', '520000', '550000'),
        ('520102', 4, '南明区', '520100', '550002'),
        ('520103', 4, '云岩区', '520100', '550001'),
        ('520111', 4, '花溪区', '520100', '550025'),
        ('520112', 4, '乌当区', '520100', '550018'),
        ('520113', 4, '白云区', '520100', '550014'),
        ('520114', 4, '小河区', '520100', '550009'),
        ('520121', 4, '开阳县', '520100', '550300'),
        ('520122', 4, '息烽县', '520100', '551100'),
        ('520123', 4, '修文县', '520100', '550200'),
        ('520151', 4, '金阳开发区', '520100', ''),
        ('520181', 4, '清镇市', '520100', '551400'),
        ('520182', 4, '其它区', '520100', ''),
        ('520200', 3, '六盘水市', '520000', '553000'),
        ('520201', 4, '钟山区', '520200', '553000'),
        ('520203', 4, '六枝特区', '520200', '553400'),
        ('520221', 4, '水城县', '520200', '553600'),
        ('520222', 4, '盘县', '520200', '561601'),
        ('520223', 4, '其它区', '520200', ''),
        ('520300', 3, '遵义市', '520000', '563000'),
        ('520302', 4, '红花岗区', '520300', '563000'),
        ('520303', 4, '汇川区', '520300', '563000'),
        ('520321', 4, '遵义县', '520300', '563100'),
        ('520322', 4, '桐梓县', '520300', '563200'),
        ('520323', 4, '绥阳县', '520300', '563300'),
        ('520324', 4, '正安县', '520300', '563400'),
        ('520325', 4, '道真仡佬族苗族自治县', '520300', '563500'),
        ('520326', 4, '务川仡佬族苗族自治县', '520300', '564300'),
        ('520327', 4, '凤冈县', '520300', '564200'),
        ('520328', 4, '湄潭县', '520300', '564100'),
        ('520329', 4, '余庆县', '520300', '564400'),
        ('520330', 4, '习水县', '520300', '564600'),
        ('520381', 4, '赤水市', '520300', '564700'),
        ('520382', 4, '仁怀市', '520300', '564500'),
        ('520383', 4, '其它区', '520300', ''),
        ('520400', 3, '安顺市', '520000', '561000'),
        ('520402', 4, '西秀区', '520400', '561000'),
        ('520421', 4, '平坝县', '520400', '561100'),
        ('520422', 4, '普定县', '520400', '562100'),
        ('520423', 4, '镇宁布依族苗族自治县', '520400', '561200'),
        ('520424', 4, '关岭布依族苗族自治县', '520400', '561300'),
        ('520425', 4, '紫云苗族布依族自治县', '520400', '550800'),
        ('520426', 4, '其它区', '520400', ''),
        ('522200', 3, '铜仁地区', '520000', ''),
        ('522201', 4, '铜仁市', '522200', '554300'),
        ('522222', 4, '江口县', '522200', '554400'),
        ('522223', 4, '玉屏侗族自治县', '522200', '554000'),
        ('522224', 4, '石阡县', '522200', '555100'),
        ('522225', 4, '思南县', '522200', '565100'),
        ('522226', 4, '印江土家族苗族自治县', '522200', '555200'),
        ('522227', 4, '德江县', '522200', '565200'),
        ('522228', 4, '沿河土家族自治县', '522200', '565300'),
        ('522229', 4, '松桃苗族自治县', '522200', '554100'),
        ('522230', 4, '万山特区', '522200', '554200'),
        ('522231', 4, '其它区', '522200', ''),
        ('522300', 3, '黔西南布依族苗族自治州', '520000', ''),
        ('522301', 4, '兴义市', '522300', '562400'),
        ('522322', 4, '兴仁县', '522300', '562300'),
        ('522323', 4, '普安县', '522300', '561500'),
        ('522324', 4, '晴隆县', '522300', '561400'),
        ('522325', 4, '贞丰县', '522300', '562200'),
        ('522326', 4, '望谟县', '522300', '552300'),
        ('522327', 4, '册亨县', '522300', '552200'),
        ('522328', 4, '安龙县', '522300', '552400'),
        ('522329', 4, '其它区', '522300', ''),
        ('522400', 3, '毕节地区', '520000', ''),
        ('522401', 4, '毕节市', '522400', '551700'),
        ('522422', 4, '大方县', '522400', '551600'),
        ('522423', 4, '黔西县', '522400', '551500'),
        ('522424', 4, '金沙县', '522400', '551800'),
        ('522425', 4, '织金县', '522400', '552100'),
        ('522426', 4, '纳雍县', '522400', '553300'),
        ('522427', 4, '威宁彝族回族苗族自治县', '522400', '553100'),
        ('522428', 4, '赫章县', '522400', '553200'),
        ('522429', 4, '其它区', '522400', ''),
        ('522600', 3, '黔东南苗族侗族自治州', '520000', ''),
        ('522601', 4, '凯里市', '522600', '556000'),
        ('522622', 4, '黄平县', '522600', '556100'),
        ('522623', 4, '施秉县', '522600', '556200'),
        ('522624', 4, '三穗县', '522600', '556500'),
        ('522625', 4, '镇远县', '522600', '557700'),
        ('522626', 4, '岑巩县', '522600', '557800'),
        ('522627', 4, '天柱县', '522600', '556600'),
        ('522628', 4, '锦屏县', '522600', '556700'),
        ('522629', 4, '剑河县', '522600', '556400'),
        ('522630', 4, '台江县', '522600', '556300'),
        ('522631', 4, '黎平县', '522600', '557300'),
        ('522632', 4, '榕江县', '522600', '557200'),
        ('522633', 4, '从江县', '522600', '557400'),
        ('522634', 4, '雷山县', '522600', '557100'),
        ('522635', 4, '麻江县', '522600', '557600'),
        ('522636', 4, '丹寨县', '522600', '557500'),
        ('522637', 4, '其它区', '522600', ''),
        ('522700', 3, '黔南布依族苗族自治州', '520000', ''),
        ('522701', 4, '都匀市', '522700', '558000'),
        ('522702', 4, '福泉市', '522700', '550500'),
        ('522722', 4, '荔波县', '522700', '558400'),
        ('522723', 4, '贵定县', '522700', '551300'),
        ('522725', 4, '瓮安县', '522700', '550400'),
        ('522726', 4, '独山县', '522700', '558200'),
        ('522727', 4, '平塘县', '522700', '558300'),
        ('522728', 4, '罗甸县', '522700', '550100'),
        ('522729', 4, '长顺县', '522700', '550700'),
        ('522730', 4, '龙里县', '522700', '551200'),
        ('522731', 4, '惠水县', '522700', '550600'),
        ('522732', 4, '三都水族自治县', '522700', '558100'),
        ('522733', 4, '其它区', '522700', ''),
        ('530000', 2, '云南省', '1', ''),
        ('530100', 3, '昆明市', '530000', '650000'),
        ('530102', 4, '五华区', '530100', '650032'),
        ('530103', 4, '盘龙区', '530100', '650051'),
        ('530111', 4, '官渡区', '530100', '650220'),
        ('530112', 4, '西山区', '530100', '650100'),
        ('530113', 4, '东川区', '530100', '654100'),
        ('530121', 4, '呈贡县', '530100', '650500'),
        ('530122', 4, '晋宁县', '530100', '650600'),
        ('530124', 4, '富民县', '530100', '650400'),
        ('530125', 4, '宜良县', '530100', '652100'),
        ('530126', 4, '石林彝族自治县', '530100', '652200'),
        ('530127', 4, '嵩明县', '530100', '651700'),
        ('530128', 4, '禄劝彝族苗族自治县', '530100', '651500'),
        ('530129', 4, '寻甸回族彝族自治县', '530100', '655200'),
        ('530181', 4, '安宁市', '530100', '650300'),
        ('530182', 4, '其它区', '530100', ''),
        ('530300', 3, '曲靖市', '530000', '655000'),
        ('530302', 4, '麒麟区', '530300', '655000'),
        ('530321', 4, '马龙县', '530300', '655100'),
        ('530322', 4, '陆良县', '530300', '655600'),
        ('530323', 4, '师宗县', '530300', '655700'),
        ('530324', 4, '罗平县', '530300', '655800'),
        ('530325', 4, '富源县', '530300', '655500'),
        ('530326', 4, '会泽县', '530300', '654200'),
        ('530328', 4, '沾益县', '530300', '655331'),
        ('530381', 4, '宣威市', '530300', '655400'),
        ('530382', 4, '其它区', '530300', ''),
        ('530400', 3, '玉溪市', '530000', ''),
        ('530402', 4, '红塔区', '530400', '653100'),
        ('530421', 4, '江川县', '530400', '652600'),
        ('530422', 4, '澄江县', '530400', '652500'),
        ('530423', 4, '通海县', '530400', '652700'),
        ('530424', 4, '华宁县', '530400', '652800'),
        ('530425', 4, '易门县', '530400', '651100'),
        ('530426', 4, '峨山彝族自治县', '530400', '653200'),
        ('530427', 4, '新平彝族傣族自治县', '530400', '653400'),
        ('530428', 4, '元江哈尼族彝族傣族自治县', '530400', '653300'),
        ('530429', 4, '其它区', '530400', ''),
        ('530500', 3, '保山市', '530000', ''),
        ('530502', 4, '隆阳区', '530500', '678000'),
        ('530521', 4, '施甸县', '530500', '678200'),
        ('530522', 4, '腾冲县', '530500', '679100'),
        ('530523', 4, '龙陵县', '530500', '678300'),
        ('530524', 4, '昌宁县', '530500', '678100'),
        ('530525', 4, '其它区', '530500', ''),
        ('530600', 3, '昭通市', '530000', '657000'),
        ('530602', 4, '昭阳区', '530600', '657000'),
        ('530621', 4, '鲁甸县', '530600', '657100'),
        ('530622', 4, '巧家县', '530600', '654600'),
        ('530623', 4, '盐津县', '530600', '657500'),
        ('530624', 4, '大关县', '530600', '657400'),
        ('530625', 4, '永善县', '530600', '657300'),
        ('530626', 4, '绥江县', '530600', '657700'),
        ('530627', 4, '镇雄县', '530600', '657200'),
        ('530628', 4, '彝良县', '530600', '657600'),
        ('530629', 4, '威信县', '530600', '657900'),
        ('530630', 4, '水富县', '530600', '657800'),
        ('530631', 4, '其它区', '530600', ''),
        ('530700', 3, '丽江市', '530000', ''),
        ('530702', 4, '古城区', '530700', '674100'),
        ('530721', 4, '玉龙纳西族自治县', '530700', '674100'),
        ('530722', 4, '永胜县', '530700', '674200'),
        ('530723', 4, '华坪县', '530700', '674800'),
        ('530724', 4, '宁蒗彝族自治县', '530700', '674300'),
        ('530725', 4, '其它区', '530700', ''),
        ('530800', 3, '普洱市', '530000', '665000'),
        ('530802', 4, '思茅区', '530800', '665000'),
        ('530821', 4, '宁洱哈尼族彝族自治县', '530800', '665100'),
        ('530822', 4, '墨江哈尼族自治县', '530800', '654800'),
        ('530823', 4, '景东彝族自治县', '530800', '676200'),
        ('530824', 4, '景谷傣族彝族自治县', '530800', '666400'),
        ('530825', 4, '镇沅彝族哈尼族拉祜族自治县', '530800', '666500'),
        ('530826', 4, '江城哈尼族彝族自治县', '530800', '665900'),
        ('530827', 4, '孟连傣族拉祜族佤族自治县', '530800', '665800'),
        ('530828', 4, '澜沧拉祜族自治县', '530800', '665600'),
        ('530829', 4, '西盟佤族自治县', '530800', '665700'),
        ('530830', 4, '其它区', '530800', ''),
        ('530900', 3, '临沧市', '530000', ''),
        ('530902', 4, '临翔区', '530900', '677000'),
        ('530921', 4, '凤庆县', '530900', '675900'),
        ('530922', 4, '云县', '530900', '675800'),
        ('530923', 4, '永德县', '530900', '677600'),
        ('530924', 4, '镇康县', '530900', '677700'),
        ('530925', 4, '双江拉祜族佤族布朗族傣族自治县', '530900', '677300'),
        ('530926', 4, '耿马傣族佤族自治县', '530900', '677500'),
        ('530927', 4, '沧源佤族自治县', '530900', '677400'),
        ('530928', 4, '其它区', '530900', ''),
        ('532300', 3, '楚雄彝族自治州', '530000', ''),
        ('532301', 4, '楚雄市', '532300', '675000'),
        ('532322', 4, '双柏县', '532300', '675100'),
        ('532323', 4, '牟定县', '532300', '675500'),
        ('532324', 4, '南华县', '532300', '675200'),
        ('532325', 4, '姚安县', '532300', '675300'),
        ('532326', 4, '大姚县', '532300', '675400'),
        ('532327', 4, '永仁县', '532300', '651400'),
        ('532328', 4, '元谋县', '532300', '651300'),
        ('532329', 4, '武定县', '532300', '651600'),
        ('532331', 4, '禄丰县', '532300', '651200'),
        ('532332', 4, '其它区', '532300', ''),
        ('532500', 3, '红河哈尼族彝族自治州', '530000', ''),
        ('532501', 4, '个旧市', '532500', '661000'),
        ('532502', 4, '开远市', '532500', '661600'),
        ('532522', 4, '蒙自县', '532500', '661100'),
        ('532523', 4, '屏边苗族自治县', '532500', '661200'),
        ('532524', 4, '建水县', '532500', '654300'),
        ('532525', 4, '石屏县', '532500', '662200'),
        ('532526', 4, '弥勒县', '532500', '652300'),
        ('532527', 4, '泸西县', '532500', '652400'),
        ('532528', 4, '元阳县', '532500', '662400'),
        ('532529', 4, '红河县', '532500', '654400'),
        ('532530', 4, '金平苗族瑶族傣族自治县', '532500', '661500'),
        ('532531', 4, '绿春县', '532500', '662500'),
        ('532532', 4, '河口瑶族自治县', '532500', '661300'),
        ('532533', 4, '其它区', '532500', ''),
        ('532600', 3, '文山壮族苗族自治州', '530000', ''),
        ('532621', 4, '文山县', '532600', '663000'),
        ('532622', 4, '砚山县', '532600', '663100'),
        ('532623', 4, '西畴县', '532600', '663500'),
        ('532624', 4, '麻栗坡县', '532600', '663600'),
        ('532625', 4, '马关县', '532600', '663700'),
        ('532626', 4, '丘北县', '532600', '663200'),
        ('532627', 4, '广南县', '532600', '663300'),
        ('532628', 4, '富宁县', '532600', '663400'),
        ('532629', 4, '其它区', '532600', ''),
        ('532800', 3, '西双版纳傣族自治州', '530000', ''),
        ('532801', 4, '景洪市', '532800', '666100'),
        ('532822', 4, '勐海县', '532800', '666200'),
        ('532823', 4, '勐腊县', '532800', '666300'),
        ('532824', 4, '其它区', '532800', ''),
        ('532900', 3, '大理白族自治州', '530000', ''),
        ('532901', 4, '大理市', '532900', '671000'),
        ('532922', 4, '漾濞彝族自治县', '532900', '672500'),
        ('532923', 4, '祥云县', '532900', '672100'),
        ('532924', 4, '宾川县', '532900', '671600'),
        ('532925', 4, '弥渡县', '532900', '675600'),
        ('532926', 4, '南涧彝族自治县', '532900', '675700'),
        ('532927', 4, '巍山彝族回族自治县', '532900', '672400'),
        ('532928', 4, '永平县', '532900', '672600'),
        ('532929', 4, '云龙县', '532900', '672700'),
        ('532930', 4, '洱源县', '532900', '671200'),
        ('532931', 4, '剑川县', '532900', '671300'),
        ('532932', 4, '鹤庆县', '532900', '671500'),
        ('532933', 4, '其它区', '532900', ''),
        ('533100', 3, '德宏傣族景颇族自治州', '530000', ''),
        ('533102', 4, '瑞丽市', '533100', '678600'),
        ('533103', 4, '潞西市', '533100', '678400'),
        ('533122', 4, '梁河县', '533100', '679200'),
        ('533123', 4, '盈江县', '533100', '679300'),
        ('533124', 4, '陇川县', '533100', '678700'),
        ('533125', 4, '其它区', '533100', ''),
        ('533300', 3, '怒江傈僳族自治州', '530000', ''),
        ('533321', 4, '泸水县', '533300', '673100'),
        ('533323', 4, '福贡县', '533300', '673400'),
        ('533324', 4, '贡山独龙族怒族自治县', '533300', '673500'),
        ('533325', 4, '兰坪白族普米族自治县', '533300', '671400'),
        ('533326', 4, '其它区', '533300', ''),
        ('533400', 3, '迪庆藏族自治州', '530000', ''),
        ('533421', 4, '香格里拉县', '533400', '674400'),
        ('533422', 4, '德钦县', '533400', '674500'),
        ('533423', 4, '维西傈僳族自治县', '533400', '674600'),
        ('533424', 4, '其它区', '533400', ''),
        ('540000', 2, '西藏自治区', '1', ''),
        ('540100', 3, '拉萨市', '540000', '850000'),
        ('540102', 4, '城关区', '540100', '850000'),
        ('540121', 4, '林周县', '540100', '851600'),
        ('540122', 4, '当雄县', '540100', '851500'),
        ('540123', 4, '尼木县', '540100', '851300'),
        ('540124', 4, '曲水县', '540100', '850600'),
        ('540125', 4, '堆龙德庆县', '540100', '851400'),
        ('540126', 4, '达孜县', '540100', '850100'),
        ('540127', 4, '墨竹工卡县', '540100', '850200'),
        ('540128', 4, '其它区', '540100', ''),
        ('542100', 3, '昌都地区', '540000', ''),
        ('542121', 4, '昌都县', '542100', '854000'),
        ('542122', 4, '江达县', '542100', '854100'),
        ('542123', 4, '贡觉县', '542100', '854200'),
        ('542124', 4, '类乌齐县', '542100', '855600'),
        ('542125', 4, '丁青县', '542100', '855700'),
        ('542126', 4, '察雅县', '542100', '854300'),
        ('542127', 4, '八宿县', '542100', '854600'),
        ('542128', 4, '左贡县', '542100', '854400'),
        ('542129', 4, '芒康县', '542100', '854500'),
        ('542132', 4, '洛隆县', '542100', '855400'),
        ('542133', 4, '边坝县', '542100', '855500'),
        ('542134', 4, '其它区', '542100', ''),
        ('542200', 3, '山南地区', '540000', ''),
        ('542221', 4, '乃东县', '542200', '856100'),
        ('542222', 4, '扎囊县', '542200', '850800'),
        ('542223', 4, '贡嘎县', '542200', '850700'),
        ('542224', 4, '桑日县', '542200', '856200'),
        ('542225', 4, '琼结县', '542200', '856800'),
        ('542226', 4, '曲松县', '542200', '856300'),
        ('542227', 4, '措美县', '542200', '856900'),
        ('542228', 4, '洛扎县', '542200', '851200'),
        ('542229', 4, '加查县', '542200', '856400'),
        ('542231', 4, '隆子县', '542200', '856600'),
        ('542232', 4, '错那县', '542200', '856700'),
        ('542233', 4, '浪卡子县', '542200', '851100'),
        ('542234', 4, '其它区', '542200', ''),
        ('542300', 3, '日喀则地区', '540000', ''),
        ('542301', 4, '日喀则市', '542300', '857000'),
        ('542322', 4, '南木林县', '542300', '857100'),
        ('542323', 4, '江孜县', '542300', '857400'),
        ('542324', 4, '定日县', '542300', '858200'),
        ('542325', 4, '萨迦县', '542300', '857800'),
        ('542326', 4, '拉孜县', '542300', '858100'),
        ('542327', 4, '昂仁县', '542300', '858500'),
        ('542328', 4, '谢通门县', '542300', '858900'),
        ('542329', 4, '白朗县', '542300', '857300'),
        ('542330', 4, '仁布县', '542300', '857200'),
        ('542331', 4, '康马县', '542300', '857500'),
        ('542332', 4, '定结县', '542300', '857900'),
        ('542333', 4, '仲巴县', '542300', '858800'),
        ('542334', 4, '亚东县', '542300', '857600'),
        ('542335', 4, '吉隆县', '542300', '858700'),
        ('542336', 4, '聂拉木县', '542300', '858300'),
        ('542337', 4, '萨嘎县', '542300', '858600'),
        ('542338', 4, '岗巴县', '542300', '857700'),
        ('542339', 4, '其它区', '542300', ''),
        ('542400', 3, '那曲地区', '540000', ''),
        ('542421', 4, '那曲县', '542400', '852000'),
        ('542422', 4, '嘉黎县', '542400', '852400'),
        ('542423', 4, '比如县', '542400', '852300'),
        ('542424', 4, '聂荣县', '542400', '853500'),
        ('542425', 4, '安多县', '542400', '853400'),
        ('542426', 4, '申扎县', '542400', '853100'),
        ('542427', 4, '索县', '542400', '852200'),
        ('542428', 4, '班戈县', '542400', '852500'),
        ('542429', 4, '巴青县', '542400', '852100'),
        ('542430', 4, '尼玛县', '542400', '852600'),
        ('542431', 4, '其它区', '542400', ''),
        ('542500', 3, '阿里地区', '540000', ''),
        ('542521', 4, '普兰县', '542500', '859500'),
        ('542522', 4, '札达县', '542500', '859600'),
        ('542523', 4, '噶尔县', '542500', '859400'),
        ('542524', 4, '日土县', '542500', '859700'),
        ('542525', 4, '革吉县', '542500', '859100'),
        ('542526', 4, '改则县', '542500', '859200'),
        ('542527', 4, '措勤县', '542500', '859300'),
        ('542528', 4, '其它区', '542500', ''),
        ('542600', 3, '林芝地区', '540000', ''),
        ('542621', 4, '林芝县', '542600', '860100'),
        ('542622', 4, '工布江达县', '542600', '860200'),
        ('542623', 4, '米林县', '542600', '860500'),
        ('542624', 4, '墨脱县', '542600', '860700'),
        ('542625', 4, '波密县', '542600', '860300'),
        ('542626', 4, '察隅县', '542600', '860600'),
        ('542627', 4, '朗县', '542600', '860400'),
        ('542628', 4, '其它区', '542600', ''),
        ('610000', 2, '陕西省', '1', ''),
        ('610100', 3, '西安市', '610000', '710000'),
        ('610102', 4, '新城区', '610100', '710005'),
        ('610103', 4, '碑林区', '610100', '710001'),
        ('610104', 4, '莲湖区', '610100', '710003'),
        ('610111', 4, '灞桥区', '610100', '710038'),
        ('610112', 4, '未央区', '610100', '710016'),
        ('610113', 4, '雁塔区', '610100', '710061'),
        ('610114', 4, '阎良区', '610100', '710089'),
        ('610115', 4, '临潼区', '610100', '710600'),
        ('610116', 4, '长安区', '610100', '710100'),
        ('610122', 4, '蓝田县', '610100', '710500'),
        ('610124', 4, '周至县', '610100', '710400'),
        ('610125', 4, '户县', '610100', '710300'),
        ('610126', 4, '高陵县', '610100', '710200'),
        ('610127', 4, '其它区', '610100', ''),
        ('610200', 3, '铜川市', '610000', '727000'),
        ('610202', 4, '王益区', '610200', '727000'),
        ('610203', 4, '印台区', '610200', '727007'),
        ('610204', 4, '耀州区', '610200', '727100'),
        ('610222', 4, '宜君县', '610200', '727200'),
        ('610223', 4, '其它区', '610200', ''),
        ('610300', 3, '宝鸡市', '610000', '721000'),
        ('610302', 4, '渭滨区', '610300', '721000'),
        ('610303', 4, '金台区', '610300', '721001'),
        ('610304', 4, '陈仓区', '610300', '721300'),
        ('610322', 4, '凤翔县', '610300', '721400'),
        ('610323', 4, '岐山县', '610300', '722400'),
        ('610324', 4, '扶风县', '610300', '722200'),
        ('610326', 4, '眉县', '610300', '722300'),
        ('610327', 4, '陇县', '610300', '721200'),
        ('610328', 4, '千阳县', '610300', '721100'),
        ('610329', 4, '麟游县', '610300', '721500'),
        ('610330', 4, '凤县', '610300', '721700'),
        ('610331', 4, '太白县', '610300', '721600'),
        ('610332', 4, '其它区', '610300', ''),
        ('610400', 3, '咸阳市', '610000', '712000'),
        ('610402', 4, '秦都区', '610400', '712000'),
        ('610403', 4, '杨陵区', '610400', '712100'),
        ('610404', 4, '渭城区', '610400', '712000'),
        ('610422', 4, '三原县', '610400', '713800'),
        ('610423', 4, '泾阳县', '610400', '713700'),
        ('610424', 4, '乾县', '610400', '713300'),
        ('610425', 4, '礼泉县', '610400', '713200'),
        ('610426', 4, '永寿县', '610400', '713400'),
        ('610427', 4, '彬县', '610400', '713500'),
        ('610428', 4, '长武县', '610400', '713600'),
        ('610429', 4, '旬邑县', '610400', '711300'),
        ('610430', 4, '淳化县', '610400', '711200'),
        ('610431', 4, '武功县', '610400', '712200'),
        ('610481', 4, '兴平市', '610400', '713100'),
        ('610482', 4, '其它区', '610400', ''),
        ('610500', 3, '渭南市', '610000', '714000'),
        ('610502', 4, '临渭区', '610500', '714000'),
        ('610521', 4, '华县', '610500', '714100'),
        ('610522', 4, '潼关县', '610500', '714300'),
        ('610523', 4, '大荔县', '610500', '715100'),
        ('610524', 4, '合阳县', '610500', '715300'),
        ('610525', 4, '澄城县', '610500', '715200'),
        ('610526', 4, '蒲城县', '610500', '715500'),
        ('610527', 4, '白水县', '610500', '715600'),
        ('610528', 4, '富平县', '610500', '711700'),
        ('610581', 4, '韩城市', '610500', '715400'),
        ('610582', 4, '华阴市', '610500', '714200'),
        ('610583', 4, '其它区', '610500', ''),
        ('610600', 3, '延安市', '610000', '716000'),
        ('610602', 4, '宝塔区', '610600', '716000'),
        ('610621', 4, '延长县', '610600', '717100'),
        ('610622', 4, '延川县', '610600', '717200'),
        ('610623', 4, '子长县', '610600', '717300'),
        ('610624', 4, '安塞县', '610600', '717400'),
        ('610625', 4, '志丹县', '610600', '717500'),
        ('610626', 4, '吴起县', '610600', '717600'),
        ('610627', 4, '甘泉县', '610600', '716100'),
        ('610628', 4, '富县', '610600', '727500'),
        ('610629', 4, '洛川县', '610600', '727400'),
        ('610630', 4, '宜川县', '610600', '716200'),
        ('610631', 4, '黄龙县', '610600', '715700'),
        ('610632', 4, '黄陵县', '610600', '727300'),
        ('610633', 4, '其它区', '610600', ''),
        ('610700', 3, '汉中市', '610000', '723000'),
        ('610702', 4, '汉台区', '610700', '723000'),
        ('610721', 4, '南郑县', '610700', '723100'),
        ('610722', 4, '城固县', '610700', '723200'),
        ('610723', 4, '洋县', '610700', '723300'),
        ('610724', 4, '西乡县', '610700', '723500'),
        ('610725', 4, '勉县', '610700', '724200'),
        ('610726', 4, '宁强县', '610700', '724400'),
        ('610727', 4, '略阳县', '610700', '724300'),
        ('610728', 4, '镇巴县', '610700', '723600'),
        ('610729', 4, '留坝县', '610700', '724100'),
        ('610730', 4, '佛坪县', '610700', '723400'),
        ('610731', 4, '其它区', '610700', ''),
        ('610800', 3, '榆林市', '610000', '719000'),
        ('610802', 4, '榆阳区', '610800', '719000'),
        ('610821', 4, '神木县', '610800', '719300');
        INSERT INTO {{%area_code}} (`id`, `type`, `name`, `parent_id`, `zip`) VALUES
        ('610822', 4, '府谷县', '610800', '719400'),
        ('610823', 4, '横山县', '610800', '719100'),
        ('610824', 4, '靖边县', '610800', '718500'),
        ('610825', 4, '定边县', '610800', '718600'),
        ('610826', 4, '绥德县', '610800', '718000'),
        ('610827', 4, '米脂县', '610800', '718100'),
        ('610828', 4, '佳县', '610800', '719200'),
        ('610829', 4, '吴堡县', '610800', '718200'),
        ('610830', 4, '清涧县', '610800', '718300'),
        ('610831', 4, '子洲县', '610800', '718400'),
        ('610832', 4, '其它区', '610800', ''),
        ('610900', 3, '安康市', '610000', '725000'),
        ('610902', 4, '汉滨区', '610900', '725000'),
        ('610921', 4, '汉阴县', '610900', '725100'),
        ('610922', 4, '石泉县', '610900', '725200'),
        ('610923', 4, '宁陕县', '610900', '711600'),
        ('610924', 4, '紫阳县', '610900', '725300'),
        ('610925', 4, '岚皋县', '610900', '725400'),
        ('610926', 4, '平利县', '610900', '725500'),
        ('610927', 4, '镇坪县', '610900', '725600'),
        ('610928', 4, '旬阳县', '610900', '725700'),
        ('610929', 4, '白河县', '610900', '725800'),
        ('610930', 4, '其它区', '610900', ''),
        ('611000', 3, '商洛市', '610000', '726000'),
        ('611002', 4, '商州区', '611000', '726000'),
        ('611021', 4, '洛南县', '611000', '726100'),
        ('611022', 4, '丹凤县', '611000', '726200'),
        ('611023', 4, '商南县', '611000', '726300'),
        ('611024', 4, '山阳县', '611000', '726400'),
        ('611025', 4, '镇安县', '611000', '711500'),
        ('611026', 4, '柞水县', '611000', '711400'),
        ('611027', 4, '其它区', '611000', ''),
        ('620000', 2, '甘肃省', '1', ''),
        ('620100', 3, '兰州市', '620000', '730000'),
        ('620102', 4, '城关区', '620100', '730030'),
        ('620103', 4, '七里河区', '620100', '730050'),
        ('620104', 4, '西固区', '620100', '730060'),
        ('620105', 4, '安宁区', '620100', '730070'),
        ('620111', 4, '红古区', '620100', '730080'),
        ('620121', 4, '永登县', '620100', '730300'),
        ('620122', 4, '皋兰县', '620100', '730200'),
        ('620123', 4, '榆中县', '620100', '\r\n730100'),
        ('620124', 4, '其它区', '620100', ''),
        ('620200', 3, '嘉峪关市', '620000', '735100'),
        ('620300', 3, '金昌市', '620000', '737100'),
        ('620302', 4, '金川区', '620300', '737103'),
        ('620321', 4, '永昌县', '620300', '737200'),
        ('620322', 4, '其它区', '620300', ''),
        ('620400', 3, '白银市', '620000', ''),
        ('620402', 4, '白银区', '620400', '730900'),
        ('620403', 4, '平川区', '620400', '730910'),
        ('620421', 4, '靖远县', '620400', '730600'),
        ('620422', 4, '会宁县', '620400', '730700'),
        ('620423', 4, '景泰县', '620400', '730400'),
        ('620424', 4, '其它区', '620400', ''),
        ('620500', 3, '天水市', '620000', ''),
        ('620502', 4, '秦州区', '620500', '741000'),
        ('620503', 4, '麦积区', '620500', '741020'),
        ('620521', 4, '清水县', '620500', '741400'),
        ('620522', 4, '秦安县', '620500', '741600'),
        ('620523', 4, '甘谷县', '620500', '741200'),
        ('620524', 4, '武山县', '620500', '741300'),
        ('620525', 4, '张家川回族自治县', '620500', '741500'),
        ('620526', 4, '其它区', '620500', ''),
        ('620600', 3, '武威市', '620000', '733000'),
        ('620602', 4, '凉州区', '620600', '733000'),
        ('620621', 4, '民勤县', '620600', '733300'),
        ('620622', 4, '古浪县', '620600', '733100'),
        ('620623', 4, '天祝藏族自治县', '620600', '733200'),
        ('620624', 4, '其它区', '620600', ''),
        ('620700', 3, '张掖市', '620000', '734000'),
        ('620702', 4, '甘州区', '620700', '734000'),
        ('620721', 4, '肃南裕固族自治县', '620700', '734400'),
        ('620722', 4, '民乐县', '620700', '734500'),
        ('620723', 4, '临泽县', '620700', '734200'),
        ('620724', 4, '高台县', '620700', '734300'),
        ('620725', 4, '山丹县', '620700', '734100'),
        ('620726', 4, '其它区', '620700', ''),
        ('620800', 3, '平凉市', '620000', '744000'),
        ('620802', 4, '崆峒区', '620800', '744000'),
        ('620821', 4, '泾川县', '620800', '744300'),
        ('620822', 4, '灵台县', '620800', '744400'),
        ('620823', 4, '崇信县', '620800', '744200'),
        ('620824', 4, '华亭县', '620800', '744100'),
        ('620825', 4, '庄浪县', '620800', '744600'),
        ('620826', 4, '静宁县', '620800', '743400'),
        ('620827', 4, '其它区', '620800', ''),
        ('620900', 3, '酒泉市', '620000', '735000'),
        ('620902', 4, '肃州区', '620900', '735000'),
        ('620921', 4, '金塔县', '620900', '735300'),
        ('620922', 4, '安西县', '620900', '743000'),
        ('620923', 4, '肃北蒙古族自治县', '620900', '736300'),
        ('620924', 4, '阿克塞哈萨克族自治县', '620900', '736400'),
        ('620981', 4, '玉门市', '620900', '735200'),
        ('620982', 4, '敦煌市', '620900', '736200'),
        ('620983', 4, '其它区', '620900', ''),
        ('621000', 3, '庆阳市', '620000', ''),
        ('621002', 4, '西峰区', '621000', '745000'),
        ('621021', 4, '庆城县', '621000', '745100'),
        ('621022', 4, '环县', '621000', '745700'),
        ('621023', 4, '华池县', '621000', '745600'),
        ('621024', 4, '合水县', '621000', '745400'),
        ('621025', 4, '正宁县', '621000', '745300'),
        ('621026', 4, '宁县', '621000', '745200'),
        ('621027', 4, '镇原县', '621000', '744500'),
        ('621028', 4, '其它区', '621000', ''),
        ('621100', 3, '定西市', '620000', '743000'),
        ('621102', 4, '安定区', '621100', '743000'),
        ('621121', 4, '通渭县', '621100', '743300'),
        ('621122', 4, '陇西县', '621100', '748100'),
        ('621123', 4, '渭源县', '621100', '748200'),
        ('621124', 4, '临洮县', '621100', '730500'),
        ('621125', 4, '漳县', '621100', '748300'),
        ('621126', 4, '岷县', '621100', '748400'),
        ('621127', 4, '其它区', '621100', ''),
        ('621200', 3, '陇南市', '620000', ''),
        ('621202', 4, '武都区', '621200', '746000'),
        ('621221', 4, '成县', '621200', '742500'),
        ('621222', 4, '文县', '621200', '746400'),
        ('621223', 4, '宕昌县', '621200', '748500'),
        ('621224', 4, '康县', '621200', '746500'),
        ('621225', 4, '西和县', '621200', '742100'),
        ('621226', 4, '礼县', '621200', '742200'),
        ('621227', 4, '徽县', '621200', '742300'),
        ('621228', 4, '两当县', '621200', '742400'),
        ('621229', 4, '其它区', '621200', ''),
        ('622900', 3, '临夏回族自治州', '620000', ''),
        ('622901', 4, '临夏市', '622900', '731100'),
        ('622921', 4, '临夏县', '622900', '731800'),
        ('622922', 4, '康乐县', '622900', '731500'),
        ('622923', 4, '永靖县', '622900', '731600'),
        ('622924', 4, '广河县', '622900', '731300'),
        ('622925', 4, '和政县', '622900', '731200'),
        ('622926', 4, '东乡族自治县', '622900', '731400'),
        ('622927', 4, '积石山保安族东乡族撒拉族自治县', '622900', '731700'),
        ('622928', 4, '其它区', '622900', ''),
        ('623000', 3, '甘南藏族自治州', '620000', '747000'),
        ('623001', 4, '合作市', '623000', '747000'),
        ('623021', 4, '临潭县', '623000', '747500'),
        ('623022', 4, '卓尼县', '623000', '747600'),
        ('623023', 4, '舟曲县', '623000', '746300'),
        ('623024', 4, '迭部县', '623000', '747400'),
        ('623025', 4, '玛曲县', '623000', '747300'),
        ('623026', 4, '碌曲县', '623000', '747200'),
        ('623027', 4, '夏河县', '623000', '747100'),
        ('623028', 4, '其它区', '623000', ''),
        ('630000', 2, '青海省', '1', ''),
        ('630100', 3, '西宁市', '630000', '810000'),
        ('630102', 4, '城东区', '630100', '810000'),
        ('630103', 4, '城中区', '630100', '810000'),
        ('630104', 4, '城西区', '630100', '810001'),
        ('630105', 4, '城北区', '630100', '810001'),
        ('630121', 4, '大通回族土族自治县', '630100', '810100'),
        ('630122', 4, '湟中县', '630100', '811600'),
        ('630123', 4, '湟源县', '630100', '812100'),
        ('630124', 4, '其它区', '630100', ''),
        ('632100', 3, '海东地区', '630000', ''),
        ('632121', 4, '平安县', '632100', '810600'),
        ('632122', 4, '民和回族土族自治县', '632100', '810800'),
        ('632123', 4, '乐都县', '632100', '810700'),
        ('632126', 4, '互助土族自治县', '632100', '810500'),
        ('632127', 4, '化隆回族自治县', '632100', '810900'),
        ('632128', 4, '循化撒拉族自治县', '632100', '811100'),
        ('632129', 4, '其它区', '632100', ''),
        ('632200', 3, '海北藏族自治州', '630000', ''),
        ('632221', 4, '门源回族自治县', '632200', '810300'),
        ('632222', 4, '祁连县', '632200', '810400'),
        ('632223', 4, '海晏县', '632200', '812200'),
        ('632224', 4, '刚察县', '632200', '812300'),
        ('632225', 4, '其它区', '632200', ''),
        ('632300', 3, '黄南藏族自治州', '630000', ''),
        ('632321', 4, '同仁县', '632300', '811300'),
        ('632322', 4, '尖扎县', '632300', '811200'),
        ('632323', 4, '泽库县', '632300', '811400'),
        ('632324', 4, '河南蒙古族自治县', '632300', '811500'),
        ('632325', 4, '其它区', '632300', ''),
        ('632500', 3, '海南藏族自治州', '630000', ''),
        ('632521', 4, '共和县', '632500', '813000'),
        ('632522', 4, '同德县', '632500', '813200'),
        ('632523', 4, '贵德县', '632500', '811700'),
        ('632524', 4, '兴海县', '632500', '813300'),
        ('632525', 4, '贵南县', '632500', '813100'),
        ('632526', 4, '其它区', '632500', ''),
        ('632600', 3, '果洛藏族自治州', '630000', ''),
        ('632621', 4, '玛沁县', '632600', '814000'),
        ('632622', 4, '班玛县', '632600', '814300'),
        ('632623', 4, '甘德县', '632600', '814100'),
        ('632624', 4, '达日县', '632600', '814200'),
        ('632625', 4, '久治县', '632600', '624700'),
        ('632626', 4, '玛多县', '632600', '813500'),
        ('632627', 4, '其它区', '632600', ''),
        ('632700', 3, '玉树藏族自治州', '630000', ''),
        ('632721', 4, '玉树县', '632700', '815000'),
        ('632722', 4, '杂多县', '632700', '815300'),
        ('632723', 4, '称多县', '632700', '815100'),
        ('632724', 4, '治多县', '632700', '815400'),
        ('632725', 4, '囊谦县', '632700', '815200'),
        ('632726', 4, '曲麻莱县', '632700', '815500'),
        ('632727', 4, '其它区', '632700', ''),
        ('632800', 3, '海西蒙古族藏族自治州', '630000', ''),
        ('632801', 4, '格尔木市', '632800', '816000'),
        ('632802', 4, '德令哈市', '632800', '817000'),
        ('632821', 4, '乌兰县', '632800', '817100'),
        ('632822', 4, '都兰县', '632800', '816100'),
        ('632823', 4, '天峻县', '632800', '817200'),
        ('632824', 4, '其它区', '632800', ''),
        ('640000', 2, '宁夏回族自治区', '1', ''),
        ('640100', 3, '银川市', '640000', '750000'),
        ('640104', 4, '兴庆区', '640100', '750001'),
        ('640105', 4, '西夏区', '640100', '750027'),
        ('640106', 4, '金凤区', '640100', '750011'),
        ('640121', 4, '永宁县', '640100', '750100'),
        ('640122', 4, '贺兰县', '640100', '750200'),
        ('640181', 4, '灵武市', '640100', '751400'),
        ('640182', 4, '其它区', '640100', ''),
        ('640200', 3, '石嘴山市', '640000', ''),
        ('640202', 4, '大武口区', '640200', '753000'),
        ('640205', 4, '惠农区', '640200', '753200'),
        ('640221', 4, '平罗县', '640200', '753400'),
        ('640222', 4, '其它区', '640200', ''),
        ('640300', 3, '吴忠市', '640000', '751100'),
        ('640302', 4, '利通区', '640300', '751100'),
        ('640303', 4, '红寺堡区', '640300', '751900'),
        ('640323', 4, '盐池县', '640300', '751500'),
        ('640324', 4, '同心县', '640300', '751300'),
        ('640381', 4, '青铜峡市', '640300', '751600'),
        ('640382', 4, '其它区', '640300', ''),
        ('640400', 3, '固原市', '640000', '756000'),
        ('640402', 4, '原州区', '640400', '756000'),
        ('640422', 4, '西吉县', '640400', '756200'),
        ('640423', 4, '隆德县', '640400', '756300'),
        ('640424', 4, '泾源县', '640400', '756400'),
        ('640425', 4, '彭阳县', '640400', '756500'),
        ('640426', 4, '其它区', '640400', ''),
        ('640500', 3, '中卫市', '640000', ''),
        ('640502', 4, '沙坡头区', '640500', '751700'),
        ('640521', 4, '中宁县', '640500', '751200'),
        ('640522', 4, '海原县', '640500', '756100'),
        ('640523', 4, '其它区', '640500', ''),
        ('650000', 2, '新疆维吾尔自治区', '1', ''),
        ('650100', 3, '乌鲁木齐市', '650000', '830000'),
        ('650102', 4, '天山区', '650100', '830002'),
        ('650103', 4, '沙依巴克区', '650100', '830000'),
        ('650104', 4, '新市区', '650100', '830011'),
        ('650105', 4, '水磨沟区', '650100', '830017'),
        ('650106', 4, '头屯河区', '650100', '830023'),
        ('650107', 4, '达坂城区', '650100', '830039'),
        ('650108', 4, '东山区', '650100', '830019'),
        ('650109', 4, '米东区', '650100', '831400'),
        ('650121', 4, '乌鲁木齐县', '650100', '830063'),
        ('650122', 4, '其它区', '650100', ''),
        ('650200', 3, '克拉玛依市', '650000', '834000'),
        ('650202', 4, '独山子区', '650200', '838600'),
        ('650203', 4, '克拉玛依区', '650200', '834000'),
        ('650204', 4, '白碱滩区', '650200', '834009'),
        ('650205', 4, '乌尔禾区', '650200', '834014'),
        ('650206', 4, '其它区', '650200', ''),
        ('652100', 3, '吐鲁番地区', '650000', '838000'),
        ('652101', 4, '吐鲁番市', '652100', '838000'),
        ('652122', 4, '鄯善县', '652100', '838200'),
        ('652123', 4, '托克逊县', '652100', '838100'),
        ('652124', 4, '其它区', '652100', ''),
        ('652200', 3, '哈密地区', '650000', '839000'),
        ('652201', 4, '哈密市', '652200', '839000'),
        ('652222', 4, '巴里坤哈萨克自治县', '652200', '839200'),
        ('652223', 4, '伊吾县', '652200', '839300'),
        ('652224', 4, '其它区', '652200', ''),
        ('652300', 3, '昌吉回族自治州', '650000', '831100'),
        ('652301', 4, '昌吉市', '652300', '\r\n831100'),
        ('652302', 4, '阜康市', '652300', '831500'),
        ('652303', 4, '米泉市', '652300', '831400'),
        ('652323', 4, '呼图壁县', '652300', '831200'),
        ('652324', 4, '玛纳斯县', '652300', '832200'),
        ('652325', 4, '奇台县', '652300', '831800'),
        ('652327', 4, '吉木萨尔县', '652300', '831700'),
        ('652328', 4, '木垒哈萨克自治县', '652300', '831900'),
        ('652329', 4, '其它区', '652300', ''),
        ('652700', 3, '博尔塔拉蒙古自治州', '650000', '833400'),
        ('652701', 4, '博乐市', '652700', '833400'),
        ('652722', 4, '精河县', '652700', '833300'),
        ('652723', 4, '温泉县', '652700', '833500'),
        ('652724', 4, '其它区', '652700', ''),
        ('652800', 3, '巴音郭楞蒙古自治州', '650000', '841000'),
        ('652801', 4, '库尔勒市', '652800', '841000'),
        ('652822', 4, '轮台县', '652800', '841600'),
        ('652823', 4, '尉犁县', '652800', '841500'),
        ('652824', 4, '若羌县', '652800', '841800'),
        ('652825', 4, '且末县', '652800', '841900'),
        ('652826', 4, '焉耆回族自治县', '652800', '841100'),
        ('652827', 4, '和静县', '652800', '841300'),
        ('652828', 4, '和硕县', '652800', '841200'),
        ('652829', 4, '博湖县', '652800', '841400'),
        ('652830', 4, '其它区', '652800', ''),
        ('652900', 3, '阿克苏地区', '650000', '843000'),
        ('652901', 4, '阿克苏市', '652900', '843000'),
        ('652922', 4, '温宿县', '652900', '843100'),
        ('652923', 4, '库车县', '652900', '842000'),
        ('652924', 4, '沙雅县', '652900', '842200'),
        ('652925', 4, '新和县', '652900', '842100'),
        ('652926', 4, '拜城县', '652900', '842300'),
        ('652927', 4, '乌什县', '652900', '843400'),
        ('652928', 4, '阿瓦提县', '652900', '843200'),
        ('652929', 4, '柯坪县', '652900', '843600'),
        ('652930', 4, '其它区', '652900', ''),
        ('653000', 3, '克孜勒苏柯尔克孜自治州', '650000', '845350'),
        ('653001', 4, '阿图什市', '653000', '845350'),
        ('653022', 4, '阿克陶县', '653000', '845550'),
        ('653023', 4, '阿合奇县', '653000', '843500'),
        ('653024', 4, '乌恰县', '653000', '845450'),
        ('653025', 4, '其它区', '653000', ''),
        ('653100', 3, '喀什地区', '650000', '844000'),
        ('653101', 4, '喀什市', '653100', '844000'),
        ('653121', 4, '疏附县', '653100', '844100'),
        ('653122', 4, '疏勒县', '653100', '844200'),
        ('653123', 4, '英吉沙县', '653100', '844500'),
        ('653124', 4, '泽普县', '653100', '844800'),
        ('653125', 4, '莎车县', '653100', '844700'),
        ('653126', 4, '叶城县', '653100', '844900'),
        ('653127', 4, '麦盖提县', '653100', '844600'),
        ('653128', 4, '岳普湖县', '653100', '844400'),
        ('653129', 4, '伽师县', '653100', '844300'),
        ('653130', 4, '巴楚县', '653100', '843800'),
        ('653131', 4, '塔什库尔干塔吉克自治县', '653100', '845250'),
        ('653132', 4, '其它区', '653100', ''),
        ('653200', 3, '和田地区', '650000', '848000'),
        ('653201', 4, '和田市', '653200', '848000'),
        ('653221', 4, '和田县', '653200', '848000'),
        ('653222', 4, '墨玉县', '653200', '848100'),
        ('653223', 4, '皮山县', '653200', '845150'),
        ('653224', 4, '洛浦县', '653200', '848200'),
        ('653225', 4, '策勒县', '653200', '848300'),
        ('653226', 4, '于田县', '653200', '848400'),
        ('653227', 4, '民丰县', '653200', '848500'),
        ('653228', 4, '其它区', '653200', ''),
        ('654000', 3, '伊犁哈萨克自治州', '650000', '835000'),
        ('654002', 4, '伊宁市', '654000', '835000'),
        ('654003', 4, '奎屯市', '654000', '833200'),
        ('654021', 4, '伊宁县', '654000', '835100'),
        ('654022', 4, '察布查尔锡伯自治县', '654000', '835300'),
        ('654023', 4, '霍城县', '654000', '835200'),
        ('654024', 4, '巩留县', '654000', '835400'),
        ('654025', 4, '新源县', '654000', '835800'),
        ('654026', 4, '昭苏县', '654000', '835600'),
        ('654027', 4, '特克斯县', '654000', '835500'),
        ('654028', 4, '尼勒克县', '654000', '835700'),
        ('654029', 4, '其它区', '654000', ''),
        ('654200', 3, '塔城地区', '650000', '834700'),
        ('654201', 4, '塔城市', '654200', '834700'),
        ('654202', 4, '乌苏市', '654200', '833000'),
        ('654221', 4, '额敏县', '654200', '834600'),
        ('654223', 4, '沙湾县', '654200', '832100'),
        ('654224', 4, '托里县', '654200', '834500'),
        ('654225', 4, '裕民县', '654200', '834800'),
        ('654226', 4, '和布克赛尔蒙古自治县', '654200', '834400'),
        ('654227', 4, '其它区', '654200', ''),
        ('654300', 3, '阿勒泰地区', '650000', '836500'),
        ('654301', 4, '阿勒泰市', '654300', '836500'),
        ('654321', 4, '布尔津县', '654300', '836600'),
        ('654322', 4, '富蕴县', '654300', '836100'),
        ('654323', 4, '福海县', '654300', '836400'),
        ('654324', 4, '哈巴河县', '654300', '836700'),
        ('654325', 4, '青河县', '654300', '836200'),
        ('654326', 4, '吉木乃县', '654300', '836800'),
        ('654327', 4, '其它区', '654300', ''),
        ('659001', 4, '石河子市', '650000', '832000'),
        ('659002', 4, '阿拉尔市', '650000', '843300'),
        ('659003', 4, '图木舒克市', '650000', '843806'),
        ('659004', 4, '五家渠市', '650000', '831300'),
        ('710000', 2, '台湾省', '1', ''),
        ('710100', 3, '台北市', '710000', ''),
        ('710101', 4, '中正区', '710100', '100'),
        ('710102', 4, '大同区', '710100', '103'),
        ('710103', 4, '中山区', '710100', '104'),
        ('710104', 4, '松山区', '710100', '105'),
        ('710105', 4, '大安区', '710100', '106'),
        ('710106', 4, '万华区', '710100', '108'),
        ('710107', 4, '信义区', '710100', '110'),
        ('710108', 4, '士林区', '710100', '111'),
        ('710109', 4, '北投区', '710100', '112'),
        ('710110', 4, '内湖区', '710100', '114'),
        ('710111', 4, '南港区', '710100', '115'),
        ('710112', 4, '文山区', '710100', '116'),
        ('710113', 4, '其它区', '710100', ''),
        ('710200', 3, '高雄市', '710000', ''),
        ('710201', 4, '新兴区', '710200', '800'),
        ('710202', 4, '前金区', '710200', '801'),
        ('710203', 4, '芩雅区', '710200', '802'),
        ('710204', 4, '盐埕区', '710200', '803'),
        ('710205', 4, '鼓山区', '710200', '804'),
        ('710206', 4, '旗津区', '710200', '805'),
        ('710207', 4, '前镇区', '710200', '806'),
        ('710208', 4, '三民区', '710200', '807'),
        ('710209', 4, '左营区', '710200', '813'),
        ('710210', 4, '楠梓区', '710200', '811'),
        ('710211', 4, '小港区', '710200', '812'),
        ('710212', 4, '其它区', '710200', ''),
        ('710300', 3, '台南市', '710000', ''),
        ('710301', 4, '中西区', '710300', '703'),
        ('710302', 4, '东区', '710300', '701'),
        ('710303', 4, '南区', '710300', '702'),
        ('710304', 4, '北区', '710300', '704'),
        ('710305', 4, '安平区', '710300', '708'),
        ('710306', 4, '安南区', '710300', '709'),
        ('710307', 4, '其它区', '710300', ''),
        ('710400', 3, '台中市', '710000', ''),
        ('710401', 4, '中区', '710400', '400'),
        ('710402', 4, '东区', '710400', '401'),
        ('710403', 4, '南区', '710400', '402'),
        ('710404', 4, '西区', '710400', '403'),
        ('710405', 4, '北区', '710400', '404'),
        ('710406', 4, '北屯区', '710400', '406'),
        ('710407', 4, '西屯区', '710400', '407'),
        ('710408', 4, '南屯区', '710400', '408'),
        ('710409', 4, '其它区', '710400', ''),
        ('710500', 3, '金门县', '710000', ''),
        ('710600', 3, '南投县', '710000', ''),
        ('710700', 3, '基隆市', '710000', ''),
        ('710701', 4, '仁爱区', '710700', '200'),
        ('710702', 4, '信义区', '710700', '201'),
        ('710703', 4, '中正区', '710700', '202'),
        ('710704', 4, '中山区', '710700', '203'),
        ('710705', 4, '安乐区', '710700', '204'),
        ('710706', 4, '暖暖区', '710700', '205'),
        ('710707', 4, '七堵区', '710700', '206'),
        ('710708', 4, '其它区', '710700', ''),
        ('710800', 3, '新竹市', '710000', ''),
        ('710801', 4, '东区', '710800', ''),
        ('710802', 4, '北区', '710800', ''),
        ('710803', 4, '香山区', '710800', ''),
        ('710804', 4, '其它区', '710800', ''),
        ('710900', 3, '嘉义市', '710000', ''),
        ('710901', 4, '东区', '710900', ''),
        ('710902', 4, '西区', '710900', ''),
        ('710903', 4, '其它区', '710900', ''),
        ('711100', 4, '新北市', '710000', ''),
        ('711200', 4, '宜兰县', '710000', ''),
        ('711300', 4, '新竹县', '710000', ''),
        ('711400', 4, '桃园县', '710000', ''),
        ('711500', 4, '苗栗县', '710000', ''),
        ('711700', 4, '彰化县', '710000', ''),
        ('711900', 4, '嘉义县', '710000', ''),
        ('712100', 4, '云林县', '710000', ''),
        ('712400', 4, '屏东县', '710000', ''),
        ('712500', 4, '台东县', '710000', ''),
        ('712600', 4, '花莲县', '710000', ''),
        ('712700', 4, '澎湖县', '710000', ''),
        ('810000', 2, '香港特别行政区', '1', ''),
        ('810100', 3, '香港岛', '810000', ''),
        ('810101', 4, '中西区', '810100', '810101'),
        ('810102', 4, '湾仔', '810100', '810102'),
        ('810103', 4, '东区', '810100', '810103'),
        ('810104', 4, '南区', '810100', '810104'),
        ('810200', 3, '九龙', '810000', ''),
        ('810201', 4, '九龙城区', '810200', '810201'),
        ('810202', 4, '油尖旺区', '810200', '810202'),
        ('810203', 4, '深水埗区', '810200', '810203'),
        ('810204', 4, '黄大仙区', '810200', '810204'),
        ('810205', 4, '观塘区', '810200', '810205'),
        ('810300', 3, '新界', '810000', ''),
        ('810301', 4, '北区', '810300', '810301'),
        ('810302', 4, '大埔区', '810300', '810302'),
        ('810303', 4, '沙田区', '810300', '810303'),
        ('810304', 4, '西贡区', '810300', '810304'),
        ('810305', 4, '元朗区', '810300', '810305'),
        ('810306', 4, '屯门区', '810300', '810306'),
        ('810307', 4, '荃湾区', '810300', '810307'),
        ('810308', 4, '葵青区', '810300', '810308'),
        ('810309', 4, '离岛区', '810300', '810309'),
        ('820000', 2, '澳门特别行政区', '1', ''),
        ('820100', 3, '澳门半岛', '820000', ''),
        ('820200', 3, '离岛', '820000', '');
EOD;
        Yii::$app->db->createCommand($sql)->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '内蒙古' where name = '内蒙古自治区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '广西' where name = '广西壮族自治区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '宁夏' where name = '宁夏回族自治区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '西藏' where name = '西藏自治区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '新疆' where name = '新疆维吾尔自治区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '香港' where name = '香港特别行政区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = '澳门' where name = '澳门特别行政区';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = REPLACE(name, '省', '') where type = 2;")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = TRIM(TRAILING '市' FROM name) where LENGTH(name) > 6 and SUBSTRING(name, -1) = '市';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = TRIM(TRAILING '自治县' FROM name) where LENGTH(name) > 6 and SUBSTRING(name, -3) = '自治县';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = TRIM(TRAILING '自治州' FROM name) where LENGTH(name) > 6 and SUBSTRING(name, -3) = '自治州';")->execute();
        Yii::$app->db->createCommand("UPDATE {{%area_code}} set name = TRIM(TRAILING '自治区' FROM name) where LENGTH(name) > 6 and SUBSTRING(name, -3) = '自治区';")->execute();

        if (Console::confirm('Remove district area data?', true)) {
            Yii::$app->db->createCommand("DELETE FROM {{%area_code}} where type >= '4';")->execute(); // remove district
        }

        return true;
    }

    public function down()
    {
        $this->dropTable('{{%area_code}}');
        return true;
    }
}

